Databases

Overview

Parsons offers support for a variety of popular SQL database dialects. The functionality is focused on the ability to query and upload data to SQL databases. Each database class also includes the ability to infer datatypes and data schemas from a Parsons table and automatically create new tables.

Similar to other classes in Parsons, the query methods for databases all return Table, which allow them to be easily converted to other data types.

There is also support for synchronization of tables between databases as part of the Database Sync framework.

• BigQuery
  • Overview
  • Quickstart
  • API
• MySQL
  • Quickstart
  • API
    • MySQL
      • MySQL.connection()
      • MySQL.query()
      • MySQL.query_with_connection()
      • MySQL.copy()
      • MySQL.table_exists()
      • MySQL.create_table()
      • MySQL.detect_data_type()
      • MySQL.format_column()
      • MySQL.format_columns()
      • MySQL.generate_alchemy_url()
      • MySQL.generate_engine()
      • MySQL.get_bigger_int()
      • MySQL.get_table_object()
      • MySQL.is_valid_sql_num()
      • MySQL.split_table_name()
• Postgres
  • Quickstart
  • API
    • Postgres
      • Postgres.copy()
      • Postgres.connection()
      • Postgres.create_table()
      • Postgres.detect_data_type()
      • Postgres.format_column()
      • Postgres.format_columns()
      • Postgres.generate_alchemy_url()
      • Postgres.generate_engine()
      • Postgres.get_bigger_int()
      • Postgres.get_table_object()
      • Postgres.is_valid_sql_num()
      • Postgres.query()
      • Postgres.query_with_connection()
      • Postgres.split_table_name()
      • Postgres.table_exists()
• Redshift
• Sqlite
  • Quickstart
  • API
    • Sqlite
      • Sqlite.query()
      • Sqlite.query_with_connection()
      • Sqlite.generate_data_types()
      • Sqlite.copy()
      • Sqlite.import_table_iteratively()
      • Sqlite.table_exists()
• Database Connector
  • API
    • DatabaseConnector
      • DatabaseConnector.table_exists()
      • DatabaseConnector.copy()
      • DatabaseConnector.query()