Getting Started
Last updated
Was this helpful?
Last updated
Was this helpful?
Community curators are granted access to a dev environment for testing and development of a data model. A member of Flipside's analytics team will need to grant you access, so please ask in the channel on Discord something along the lines of:
Hi , I’m interested in doing data curation for Flipside, could you give me snowflake access please? I’d like my username to be:
community_<insert_username>
Access to Snowflake is granted for the sole purpose of community curation and testing your models. This password is not to be shared with anyone. If you know someone who would like to contribute as well, we will credential them separately. If you would like to work with Flipside data in a Snowflake environment, please see the section on Data Shares and reach out separately.
If you are unfamiliar with dbt, we suggest creating a free account to . dbt Labs has built an IDE for developing dbt models. Once the environment is set up with the proper credentials, connect to a fork of the to begin editing or building you own. The cloud environment includes the option to preview the compiled SQL models so you can see output as you work. Additionally, the command line for running dbt includes built-in autocomplete for common dbt commands.
If you don't already have it installed, install git to your machine. are that may assist you.
You will also need a account to collaborate on the model repositories. Github also has an official command line tool, , that is useful for interacting with Github repositories.
Once set up, clone a copy of the repository of choice to your machine and checkout a branch to begin making your changes. Branch name should follow the convention:community/<branch_name>.
Ex: git checkout -b community/my-new-model
We have included a Dockerfile in eligible repositories to handle the installation of dbt on your behalf.
Open a terminal window in the repository directory and run the command make dbt-console. If successful, a Docker container should spin up, install dbt, and open a console for you to run dbt commands. The container will read your .env file and should be connected to operate on the community curation database.
Test your connection!
Run dbt debug to check installation.
Run dbt test -s core__fact_blocks to run a set of tests on the <chain>.core.fact_blocks model in the community curation database to check your connection and credentials.
Clone a repository, like
to your machine.
Copy the details of to a .env file with your credentials. The environment details, like account and database, will be pre-filled for you. All you should need to replace is the below with your previously provided username and password.
Run dbt deps to install dependencies listed in the .
If you run into any errors, reach out for assistance in the !
Make is not recognized as a native command on Windows machines. As such, you will either need to install make for Windows, or use a Linux Terminal via .
You can use any code editor, but is our recommendation due to available extensions. All code that is to be suggested via PR must be formatted correctly using the .
The extension is also recommended.
You are now ready to create your first data contribution! Read on for an example contribution guide which includes some dbt basics, or review the for insight on how we structure our projects.