Skip to main content

Rill 0.31 โ€“ Support for BigQuery; Timezone selector

ยท 2 min read
note

โšก Rill Developer is a tool that makes it effortless to transform your datasets with SQL and create fast, exploratory dashboards.

To try out Rill Developer, check out these instructions and let us know over on Discord if you encounter any problems or have ideas about how to improve Rill Developer!

big-query

BigQuery connector - Data warehouses like BigQuery are often used as an analytics-ready source of truth. Though Rill doesn't require a data warehouse to start understanding data, it might make more sense to directly tap into this refined data source when it is available. With this release, we include a new connector that allows you to directly pull down a table through a SELECT statement from your BigQuery data warehouse. This is a similar functionality as our new MotherDuck connector and we hope you find it just as useful.

Let us know how our new connectors helped you quickly build and deploy dashboards in our discord channel.

Timezone selector - The modern business landscape spans multiple timezones, adding complexity to the interpretation of timeseries metrics. For example, there are 4 timezones in the contiguous United States alone and people working across these timezones might want insights that represent local time. This update of Rill lets you set the default timezone during development with the ability to personalize the timezone selected in your cloud dashboard. This feature will empower you and your team to swiftly grasp insights and take decisive action across the globe, no matter where your partners or clients may be located.

Our application assumes that dates and timestamps lacking timezone information are in UTC. To ensure you get the precise results you're after, you may need to cast your dates into the correct timezone. Try a variation of this CAST statement during modeling to set your timezone appropriately.

TIMEZONE('America/Chicago', DATE '2023-07-01') AS tranform_timezone