Quickstart
Get up and running with Quill in less than a minute
1. Create a read-only user
To create a read-only user in PostgreSQL, do the following:
Create a new user
Grant CONNECT privileges
Grant USAGE on the schema
Grant SELECT privileges on the schema
The connection string for the read-only user we just created will be something like: postgresql://quill_read_only:password@db.example.com:5432/your_database
.
To create a read-only user in PostgreSQL, do the following:
Create a new user
Grant CONNECT privileges
Grant USAGE on the schema
Grant SELECT privileges on the schema
The connection string for the read-only user we just created will be something like: postgresql://quill_read_only:password@db.example.com:5432/your_database
.
To create a read-only user in Big Query, do the following:
Create a service account for Quill
In the Google Cloud Console, navigate to the IAM & Admin > Service Accounts page. Click Create Service Account
and follow the prompts to create a new service account.
Grant permissions to the service account
Grant the bigquery.dataViewer
role to the service account for a dataset. You can do this by navigating to the dataset’s Permissions page and adding the service account with the bigquery.dataViewer
role.
Create the access token
Create a new JSON key for the service account by clicking the Actions
dropdown next to the service account on the IAM & Admin > Service Accounts page, and then selecting Create Key
. Select JSON
as the key type and click Create
. This will prompt you to save it one your local machine.
In the next step you’ll upload this JSON file into the Quill Portal.
To create a read-only user in Snowflake, do the following:
Create a new user
Create a new read-only role
Grant SELECT privileges to the role
Assign the user to the role
To create a read-only user in MySQL, do the following:
Create a new user
Grant USAGE on the schema
The connection string for the read-only user we just created will be something like: mysql://quill_read_only:password@db.example.com:3306/your_database
.
2. Connect your database
Go to https://app.quill.co/onboard and enter the read-only database connection string that we created in the last step.
If you’re using our fully-managed Quill instance, make sure to add the Quill
server to your database IP whitelist, if you have one. Requests from Quill
will always come from 34.133.137.225
.
For more information about data and access control, you can read our self-hosting guide here.
3. Connect your schema
The Quill platform provides powerful filtering and reporting tools to help you get the insights you want, faster. Since Quill provides organization-based filtering out-of-the-box, simply let us know which table to use and Quill will automatically partition your data by organization.
4. Add SQL Views
Create a cleaned schema that makes it easier to write queries and reports. The views you create here will be used to create charts and tables later on. Don’t worry, you can always create and edit these views later.
Next Steps
Once you have connected your database, you’re ready to create your first dashboard! Check out our guides on how to create your first dashboard below.
Create a dashboard
Build your first dashboard with Quill in less than a minute.