LookML and SQL to external database

AnnS
Participant I

Situation: I have a results table that shows whether a specific job has successfully run or errored.  I have imported that summary table from a snowflake instance.  

Each of those jobs also has a table associated with it in snowflake - this table shows the details of any errors that occur. 

So, this summary table has job1, job2, jobabc, (let’s call the fieldname jobname) and there are associated tables in snowflake named job1, job2, jobabc - one for each job, and there’s an increasing number of these jobs that will occur. 
 

Is there a way to query from the LookML for the summary table the associated tables?  Something like select * from database.schema.[jobname] (where jobname is the table name in the external database) or am I going to have to create another table that unions all those job tables (and bring that into Looker) so I can display any errors?  

1 0 101
0 REPLIES 0
Top Labels in this Space
Top Solution Authors