Plotly
app

Big Data Pipelines

Dash Enterprise > Enterprise IT Integration > Big Data Pipelines

Dash Enterprise is your front end for horizontally scalable, big data computation in Python.

Since Python connects to any database, it's easy to empower business users with Dash apps that connect to your databases, query data, perform advanced analytics in Python, and even write back results. As the world's fastest growing language, every database vendor offers a Python connector library (see table below). That's great news for Dash users building analytics apps that connect to databases.

For example, your Dash app might connect to a Snowflake database with Python's Snowflake connector, read customer reviews, perform NLP sentiment analysis, then email a PDF report with Snapshot Engine.

Dash Enterprise ships with battle-tested, plug-and-play Dash app demos for connecting to Snowflake, Databricks, Postgres, Redis, BigQuery, Salesforce, and Redshift. These demos show best practices for connecting and querying databases in Python. Scroll below to demo Python Dash apps that connect to today's most back-end popular databases.

Get pricing

Connector Templates
Connect Any Data Pipeline
Vaex
Dask
Datashader
Databricks
Snowflake
Postgres
Salesforce
Secrets Manager

Connector Templates.

Dash Enterprise ships with plug & play Dash app templates for connecting to these and other data services in Python. These templates demonstrate best practices such as:

• Using the Dash Enteprise Jobs Queue

• Connection pooling

• Preventing SQL injection attacks

• Reading SQL query results into Pandas dataframes

• Secure database authentication with the Dash Enteprise Secrets Manager 

"We are not speaking just about reports/dashboards. Dash helps us to organize and combine our data and make it available for a wider spectrum of colleagues, who may require in the future some kind of interaction, such as running finite element simulations for specific parameter combinations."

Senior Simulation Engineer at High-Performance Automobile Manufacturer

Python connects to any database.

This makes it simple to connect your Dash apps to any database, perform AI & ML routines in Python on the data, then deliver these insights to business users as Dash apps.

  1. Database
  1. Python connector library name
  1. Python library downloads per month
  1. Installation command
  1. Dash app example
  1. Documentation
  1. MySQL
  1. mysql-connector-python
  1. 3M
  1. pip install mysql-connector-python
  1. Contact sales
  1. Querying data
  1. Postgres
  1. pyscopg2
  1. 9M
  1. pip install psycopg2-binary
  1. Contact sales
  1. Basic usage
  1. Snowflake
  1. snowflake-connector-python
  1. 6M
  1. pip install snowflake-connector-python
  1. Sentiment analysis app
  1. Querying data
  1. Google BigQuery
  1. google-cloud-bigquery
  1. 10M
  1. pip install google-cloud-bigquery
  1. Contact sales
  1. Perform a query
  1. Amazon RedShift
  1. redshift_connector
  1. 1M
  1. pip install redshift_connector
  1. Contact sales
  1. Basic example
  1. MS Azure SQL
  1. pyodbc
  1. 7M
  1. pip install pyodbc
  1. Contact sales
  1. Azure SQL Database libraries for Python
  1. Redis
  1. redis
  1. 14M
  1. pip install redis
  1. Redis on Dash Enterprise
  1. redis-py
  1. MongoDB
  1. pymongo
  1. 8M
  1. pip install pymongodb
  1. Contact sales
  1. Tutorial
  1. Elasticsearch
  1. elasticsearch
  1. 11M
  1. pip install elasticsearch
  1. Contact sales
  1. Python Elasticsearch Client
  1. Databricks
  1. databricks-connect
  1. 600k
  1. pip install databricks-connect
  1. Yelp review app
  1. Azure | AWS
  1. Postgres, MySQL, SQLite, Oracle, and MS SQL
  1. sqlalchemy
  1. 23M
  1. pip install sqlalechemy
  1. Connect a Dash app to a SQL database
  1. SQL Alchemy Dialects
  1. Salesforce
  1. simple-salesforce
  1. 2M
  1. pip install simple-salesforce
  1. Salesforce Dash app
  1. Simple Salesforce

Connect your Dash apps to all major data warehouses.

📚 Python supports best-in-class, open-source connection libraries for Snowflake, Amazon Redshift, IBM DB2, Google BigQuery, PostgreSQL, and Azure SQL Data Warehouse, making it simple to connect these data services to your Dash apps. Dash Enterprise comes with connection examples for each of these data warehouses, so you can easily copy/paste the code into your own Dash apps.

🐼 Use Pandas dataframes in Data Science Workspaces or your Dash application code to rapidly filter and visualize data warehouse query results.

Use the Dash Enterprise Job Queue to sideline long-running data warehouse queries and accelerate your Dash application performance.

Dash Enterprise Architecture

We're proud to partner with these best-in-class big data Python solutions.

See Dash in action

Sign up for our next Dash Live Weekly demo session to learn more about our Dash Enterprise offering, including industry applications and all the latest tips and features on how to operationalize your data science models.

Please fill all *required* fields