Hi All,
My use case is very simple. I would like to do following things.
- Connect to snowflake database using airtable script?
- Fetch data from snowflake table.
- Populate the grabbed data into airtable multi select field as option.
I know the answer for third point as shown below. But didn’t find an relevant resource or answer for first 2 points.
Does anybody know how to connect to snowflake database using airtable script?
const multipleSelectField = table.getField('My multiple select field');
await multipleSelectField.updateOptionsAsync({
choices: [
...multipleSelectField.options.choices,
{name: 'My new choice'},
],
});