Unlike a traditional BI platform, Datapane does not offer a proprietary set of connectors for pulling data. Instead, you are free to use the Python ecosystem to connect to third-party platforms, such as your data warehouse, internal APIs, etc. This also enables the ability to pull and join data from multiple sources.
When scripts run on Datapane, they have full network access to allow you to connect out to other platforms.
If you are connecting to a third-party datastore, it may require a form of authentication. To make this flow easier, Datapane provides a User Variables API. This enables you to securely store, share, and retrieve sensitive values.
Please see the relevant documentation for more information on managing secrets.
If you are connecting to a database or warehouse and need to include SQL files, you can package these up in your script deployment by copying them into your script's folder and including them in your