snowflake-cloud-data-platform - Connect to MS Access Database from Snowflake

Question

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.

标签： snowflake-cloud-data-platform

Answer 1

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