Skip to main content

Hi All,
My use case is very simple. I would like to do following things.

  1. Connect to snowflake database using airtable script?
  2. Fetch data from snowflake table.
  3. 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'},
    ],
});

You can use the Skyvia cloud data integration platform to connect Snowflake and Airtable with no coding. It is freemium