Adding CSV upload functionality and mapping columns to BigQuery table

💬 Queries and Resources
2

Hey @mondob!

Using fileInput.parsedValue[0] you should be able to get a JSON representation of your CSV as long as Parse files is turned on:

With that, you might try using a Query JSON with SQL query to map the columns with something like:

SELECT col1 AS alias1, col2 AS alias2 FROM {{ fileInput.parsedValue[0] }}

Does that sound like it could work?

If you prefer to use JavaScript something like this may also do the trick :thinking: