Accessing Data from MySQL
Magpie offers the MySQL data source, which provides users the ability to connect to MySQL databases through a standard JDBC Connector. The MySQL data source…
Creating and Managing Data Sources
As described in the overview of Magpie's metadata, all tables within Magpie are backed by an underlying data source. There are several types of data sources:
Accessing Data from Distributed File Systems
Another common type of data source used within Magpie is a distributed file system. File system sources can be object stores like AWS S3, Azure Storage, or…
Accessing Data from JDBC Sources
One of the most common sources for data used within Magpie are relational databases that can be queried using SQL over JDBC. Amazon Redshift supports…
Accessing Data from Redshift
Cloud-based data warehouses such as Amazon Redshift are frequently used in analytics. Magpie can access data from Redshift using specialized connectors.
Accessing Data from Snowflake
Cloud-based data warehouses such as Snowflake are frequently used in analytics. Magpie can access data from Snowflake using a specialized connector. The…
Accessing Data from BigQuery
Cloud-based data warehouses such as Google BigQuery are frequently used in analytics. Magpie can access data from BigQuery using specialized connectors.
Accessing Data from PostgreSQL
Magpie offers the PostgreSQL data source, which provides users the ability to connect to PostgreSQL databases through standard JDBC connections or through the…
Accessing Data from Kafka
Apache Kafka is a distributed streaming platform that has three key capabilities:
Accessing Data from Generic Sources
Magpie supports access to any type of data source supported by the underlying Spark environment using a generic data source type. This provides more…
Loading Data from URL
Data can also be imported into Magpie from external sources, in particular web and other URL sources. Using the SAVE URL AS TABLE command, you can specify a…
Exporting Data from Magpie
Mapgie provides several mechanisms to export data. Typical use cases for downloading from Magpie include creating spreadsheets to share with non-technical…