Change Flux to SQL sync


I am encountering a problem for which I couldn’t find much information online…

I had created a test account to get familiar with the technology and understand how it works. I was able to successfully create different buckets and link them with Grafana without any issues. These buckets were automatically created with SQL sync, and I could write SQL queries and so on in your platform without any problems.

However, after we started setting up the infrastructure and got a subscription in Azure with the new Azure account, all the buckets I create (which I create the same way) are in Flux query language instead of SQL…

How can I create new buckets so that they are in SQL instead of Flux? Is this setting supposed to be in Azure? I looked for it and couldn’t find it (or maybe I missed it lol).

The top screenshot is from the Azure subscription
And the bottom is from the 1st created testing account

Same information is uploaded but different query languages are applied…
It’s not necessary to be SQL even InfluxQL is fine!

@mahitsy Sorry, just going to start off with some background. There are actually two versions of InfluxDB Cloud: InfluxDB Cloud (v2) and InfluxDB Cloud Serverless (v3). InfluxDB Cloud (v2) is built on top of the TSM storage engine. InfluxDB Cloud Serverless is built on top of the InfluxDB v3 storage engine (IOx). The TSM storage supports Flux and InfluxQL, but not SQL. The InfluxDB v3 storage engine supports SQL, InfluxQL, and (in a very limited way) Flux.

Your first account was created on InfluxDB Cloud Serverless and uses the v3 storage engine. InfluxDB Cloud Serverless is currently only available on AWS. When you signed up for InfluxDB Cloud through the Azure marketplace, you signed up for InfluxDB Cloud v2. InfluxDB Cloud Serverless is not yet available through Azure and GCP marketplaces. There is a note with more information at the top of this page.

With that said, to use SQL in the UI again, you’ll need to use and InfluxDB Cloud Serverless account. The catch here is that it’s not currently available on Azure. You can use InfluxQL with both v2 and v3 storage engines, but neither UIs support InfluxQL in the Data Explorer (at least right now).

1 Like

Thanks for the comprehensive answer! :slight_smile: