I'm implementing a custom SQL parser (Snowflake di...
# ingestion
h
I'm implementing a custom SQL parser (Snowflake dialect) for use with for example the LookML integration. I'm looking at the get_columns function, and can't really figure out what the output should be. Is it supposed to return the "schema" of the lookml view, or the source columns from a lineage point of view? Based on the tests it's only the column names, without any possible source table prefix?
d
it returns the columns from the sql query
without the schema name
so if your query is
select a, b, c from mytable
then it should return
a
and
b
and
c
h
Thanks! And digging through the code shows that the name-strings end up in
ViewField
- objects, which in turn are used to generate the schema.
👍 1