Brian Hirst (brian@themedialab.agency)
2024-08-08 12:14:27

Hey James, I had a DBT>Bigquery question. Did you have a minute?

James Scott (jamesscott@shield-legal.com)
2024-08-08 12:16:31

Yes!

James Scott (jamesscott@shield-legal.com)
2024-08-08 12:16:53

Wanna use this

Brian Hirst (brian@themedialab.agency)
2024-08-08 12:17:08
James Scott (jamesscott@shield-legal.com)
2024-08-08 12:45:40

connect to this table SELECT ** FROM tort-intake-professionals.<a href="http://tip_prod_application.lr">tip_prod_application.lr</a>_case_type_join LIMIT 1000

James Scott (jamesscott@shield-legal.com)
2024-08-08 12:45:49

remove the limit though

Brian Hirst (brian@themedialab.agency)
2024-08-08 12:47:26

Thank you James🙌

James Scott (jamesscott@shield-legal.com)
2024-08-08 13:11:38

Did it work

Brian Hirst (brian@themedialab.agency)
2024-08-08 13:12:40

I had to jump into a call, I'll try when done presenting