https://datahubproject.io logo
Join Slack
Powered by
LookML ingestion does not appear to be correctly p...
# troubleshoot
p
LookML ingestion does not appear to be correctly parsing table names from all of our view files Context: datahub-lookml version: 
0.8.26.3
(also tried this on latest pip version 
0.8.27.1
) We use BQ with looker There were no errors associated with this view in the logs parse_table_names_from_sql is set to 
true
I have double checked the view definition in datahub and it matches what we have in Looker, there are very clearly 3-4 tables that were not picked up by ingestion, and one that was ingested incorrectly
Also is this the right command to get debug logs? 
datahub --debug ingest -c lookml_to_datahub.yml
I only see debug logs for the config, but nothing from the actual lookml plugin itself
m
@plain-farmer-27314: that looks right, surprising that it doesn't turn on debug logs for the connector
Can you tell us a bit more about the views that weren't parsed correctly?
in terms of what types of lookml capabilities they were using
p
Yeah having the debug logs would help to see what's going on locally here... As far as capabilities, the view just contains a derived_table, measures, and dimensions the SQL for the derived table doesn't contain any variables, just plain ol sql
happy to send the SQL of the derived table mentioned above in a DM if that would help
r
🙏
2 Views
Open in Slack
PreviousNext
Powered by