CODEWITHSUNDEEP
snowflake-cloud-data-platform
Christopher Turnbull
Christopher Turnbull

Reputation: 1003

Connect to MS Access Database from Snowflake

I can't really find anything online about how to do this. There are a few separate, offline, Microsoft Databases existing...

Everyone has begun staging different .accdb files in an Amazon S3 bucket - I'm hoping Snowflake now provides an easy (ish) solution to reading them into the SQL database I'm building.

Upvotes: 0

Views: 2722

Answers (2)

NickW
NickW

Reputation: 9798

The short answer is that you can't. Snowflake can import text files in various formats (csv, XML, JSON, etc) but is has no extract capabilities so it can't connect to applications and read data from them: asking it to read a MS Access file is no different from asking it to read an Oracle or SQL Server file.

You probably have 2 options:

  1. Export the data from MS Access to a file format that Snowflake can ingest
  2. Use an ETL tool that can read from MS Access and write to S3 as text files (or directly to Snowflake, which is probably simpler

Upvotes: 2

Clement
Clement

Reputation: 194

You should be able to connect to Snowflake in Microsoft Access through an ODBC connection. You first need to install the Snowflake ODBC Driver and configure a DSN.

Upvotes: 1

Related Questions