Your own data: Snowflake and Google Drive

Query your Snowflake warehouse and read the Google Drive files you've shared with GoMarble.

Written By GoMarble

Last updated About 17 hours ago

Query your data warehouse, and read the documents and sheets you've shared with GoMarble.

Works in GoMarble chat and in AI assistants connected through GoMarble MCP. New to GoMarble MCP? See GoMarble MCP - Overview and How to connect GoMarble MCP.

Before you start

Connect Snowflake in Settings → Integrations. See How to Connect a Snowflake Account. GoMarble runs the SQL as written, so connect with a Snowflake role that can only read the data you want the assistant to see.
Google Drive uses your Google Sheets / Drive connection. GoMarble only sees files it created or that you picked in the Google file picker, not your whole Drive. See How to Connect Google Sheets.
Right now the Google Drive tools work in GoMarble chat only. External AI assistants can't be given Drive access yet.

Things you can ask

"Run this query on Snowflake and chart weekly revenue."
"Read the 'Q4 plan' doc and list the campaigns it mentions."
"Save the file at this link to my Drive."

Read tools only look at data. Change (asks first) tools show you exactly what will change and apply it only after you confirm. Change (runs right away) tools act without a separate confirm step, and the assistant only uses them when you ask.

Snowflake

Tool	What it does	Type
`snowflake_execute_query`	Runs a SQL query on your Snowflake warehouse.	Read

Google Drive

The two change tools need Write access on your Google Sheets / Drive connection.

Tool	What it does	Type
`google_drive_search_files`	Finds Drive files by name or content.	Read
`google_drive_read_file`	Reads a Google Doc, Sheet, Slides deck or text file as text. Large files are read in parts.	Read
`google_drive_upload_from_url`	Saves a file from a public web link into your Drive. The saved file stays private. Up to 100 MB.	Change (runs right away)
`google_drive_prepare_media_url`	Makes a public, hard-to-guess copy of a Drive image or video on GoMarble's media storage so it can be used in ads (for example Performance Max). The link does not expire. Your original file and its sharing settings don't change.	Change (runs right away)