Hey!
I’m trying to define an external table from a Google sheet in Dataform - only a few columns from a specific sheet should be used.
Some AI tools are saying that ‘range’ can be used in OPTIONS, but I guess it’s misleading - I’m getting “Syntax error: Unexpected keyword RANGE”.
OPTIONS( range = ‘Sheetname!A1:E’ )
Is there a workaround or currently this is not something supported?
Thank you!