Dustin Surwill (dsurwill@shield-legal.com)
2025-08-18 15:34:36
Lawruler lr_data ERD.png
🙏 CC Kitanovski
CC Kitanovski (ckitanovski@shield-legal.com)
2025-08-18 15:42:54

many thanks!

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-18 15:44:16

Thats for the database that I made that copies the LawRuler data every 15 minutes. You can access it via Postgres or BigQuery if you have permission.

CC Kitanovski (ckitanovski@shield-legal.com)
2025-08-18 15:45:31

is that the financiallogdataset ?

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-18 15:46:04

no, lr_data

CC Kitanovski (ckitanovski@shield-legal.com)
2025-08-18 15:46:23

ah okay he had me star that one, too

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-18 15:46:24

Those are BigQuery views into the data in Postgres

CC Kitanovski (ckitanovski@shield-legal.com)
2025-08-22 14:13:25
image.png
CC Kitanovski (ckitanovski@shield-legal.com)
2025-08-22 14:15:49

https://github.com/crystalkitanovski

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-22 15:41:39

Github has been invited. Plan to do AI stuff?

CC Kitanovski (ckitanovski@shield-legal.com)
2025-08-22 15:42:02

that's honestly a really good question.

CC Kitanovski (ckitanovski@shield-legal.com)
2025-08-22 15:42:07

i will tentatively say yes.

👍 Dustin Surwill
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-22 15:45:20

you are now a part of the ai-dev@shield-legal.com distribution list, which is used to help control permissions in GCP

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-22 15:45:28

So that query should work now

CC Kitanovski (ckitanovski@shield-legal.com)
2025-08-22 15:47:39

it still said nope.

CC Kitanovski (ckitanovski@shield-legal.com)
2025-08-22 15:48:15

that's a next week problem.

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-22 15:48:44

now should be fixed

CC Kitanovski (ckitanovski@shield-legal.com)
2025-08-22 15:49:41

it is doing a thing!

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-22 15:51:10

should order by triggered_at desc to show the latest on top