Blueprint Library
Definitionβ
The Blueprint Library is a location for pre-made Blueprints developed by Shipyard staff. These Blueprints provide an easy way to avoid monotonous development work associated with integrations.
Library Blueprints are designed to:
- Accomplish a single common action with a single vendor
- Require minimal details and credentials to get started
- Require no coding
Library Blueprints are immediately available to every user in an organization. These Blueprints are constantly updated and monitored by our team. If you run into connection issues or general errors, contact support@shipyardapp.com
In an effort to be transparent about how our Blueprints work, we open-source the code and make it available in a single repository on our GitHub. The repository is broken up into folders by vendor. If some functionality isn't working appropriately, you can open an issue in GitHub or submit a pull request with the proposed changes.
Free Blueprintsβ
A portion of our Blueprints are 100% free, never incurring billable runtime. These Blueprints are marked with "Trigger" in the name and are labeled in the application as "Free".
For example, you may run a job on an external service like dbt Cloud, a process that could take multiple hours to finish. The majority of runtime in these instances is spent waiting for the external service to finish running the job rather than actively processing data on our platform. Instead of charging customers for this "wait time", we choose to make these Blueprints free because their primary function is orchestrating the external service to run a job.
Our definition of Free Blueprints is always evolving. If there's ever a Blueprint you feel meets this condition that isn't classified as free, please reach out to support.
Structure of the Blueprint Libraryβ
Blueprints are broken down into a few categories with core functionality that should be achieved. The following is a list of the integrations currently built out and the common actions related to each category.
Databasesβ
Integrationsβ
- Amazon Athena
- Amazon Redshift
- Databricks SQL Warehouse
- Google BigQuery
- Microsoft SQL Server
- MySQL
- PostgreSQL
- Snowflake
Actionsβ
- Execute SQL Query
- Download Query Results to Shipyard
- Upload File to Table from Shipyard
Cloud Storageβ
Integrationsβ
Actionsβ
- Download Files to Shipyard
- Upload Files from Shipyard
- Move or Rename Files
- Delete Files
Spreadsheetsβ
Integrationsβ
Actionsβ
- Download Sheet to Shipyard
- Upload File to a Sheet from Shipyard
- Clear Sheet Contents
Messagingβ
Integrationsβ
Actionsβ
- Send Message
- Send Message Conditionally
- Send Message w/ Attachment
Data Visualizationβ
Integrationsβ
Actionsβ
- Download Dashboard/View/Card/Report as File to Shipyard
- Trigger Dataset Refresh
Data Tooling (Ingestion, Transformation, Reverse ETL, and Syncing)β
Integrationsβ
Common Actionsβ
- Trigger Job
- Download Results from Job to Shipyard
- Trigger Job and Download Results to Shipyard (All-in-one)
Project Managementβ
Integrationsβ
Actionsβ
- Create Task
- Edit Task
Customer Resource Management (CRM)β
Integrationsβ
Actionsβ
- Download Data to Shipyard
- Upload Data from Shipyard
3rd-Party APIsβ
Integrationsβ
Actionsβ
- HTTP Request
- Download File from URL to Shipyard
File or Data Manipulationβ
Integrationsβ
Actionsβ
- Compress Files
- Decompress Files
- Convert Files
- Compare File Contents