The data on your Elementary Cloud environments is updated by syncing the local Elementary schema from the data warehouse.
There are 2 available scheduling options:
When configuring a webhook, the environment will update as soon as new data is available, ensuring you see the most recent data while minimizing unnecessary updates and therefore cost.
To configure the webhook, navigate to the relevant environment on your Environments page in Elementary Cloud. Click the environment’s Schedule Settings and change the environment update method to “Webhook triggered”. The next step depends on whether you’re using dbt Cloud or dbt Core.
In the Schedule Settings, you’re provided with a webhook URL. Next, you will need to provide a secret token that will be returned from dbt Cloud.
Heading to dbt Cloud, you can create a webhook subscription that will trigger a sync after your jobs are done.
Run completed
events.After completing the guide, you’ll be provided with the secret token that you’ll need to fill in the form on Elementary Cloud. Press Save and you’re done!
If you’re using dbt Core and have a custom orchestration layer such as Airflow or Prefect, you can use the webhook URL and the secret generated by Elementary in the Schedule Settings to trigger a sync after your dbt job.
In the following code snippet,
replace <SECRET>
and <WEBHOOK_URL>
with the secret and webhook URL provided in the Schedule Settings and run it after your dbt job has finished.
Make sure to click Save after filling in the form.