SQL reports in dashboard

I know we can have snowflake to run SQL queries but can we have complex SQL that will used to generate a chart or number?

Also, do we have flexibility to add UI controls (dropdown, label, etc) like we have in Google Data Studio?

Find more posts tagged with

Event

Accepted answers

Saish Redkar

Hey imranku07

There is an Amplitude Query add-on which allows customers to write custom SQL against their Amplitude data directly inside the Amplitude platform. You can try this one if you want to run your SQL queries inside Amplitude UI and generate the charts accordingly as shown in the doc.

As of today, there isn’t much flexibility in the charts for adding custom UI controls that you mentioned. Amplitude isn’t a full fledged custom data viz platform yet as compared to tools like Google Data Studio. There is some level of customization you can do while creating dashboards and templates, but I don’t think that’s what you are looking for here.

Hope this helps.

All comments

Saish Redkar

Hey imranku07

Hope this helps.

Quick Links

Unanswered Questions

Guide and Survey Analytics not Working
Hey there I've been playing around for a couple of hours with the guide and analytics which fires properly on the UI but wouldn't give me any analytics. I read that there is another script that should be installed for the analytics part of things. Would anyone be able to guide me towards the potential script or some…
How can I connect my Google Analytics Data with Amplitude
All my data is being collected through Firebase I want to export all this data in Amplitude and keep it synced with GA4, I tried adding data sources as BigQuery and GA4 both but for some reason it only partially imported the data and now its not working, I cant even see connected sources. Any help will be appreciated.
Import data from one amplitude account to another
How do I transfer data from one amplitude account to another? It seems all the community chats about this have completely broken links. Easy to export, no way to import, very frustrating. :(
@amplitude/plugin-web-vitals-browser build fails on CRA v4 (react-scripts@4.0.3)
When using @amplitude/plugin-web-vitals-browser with Create React App v4 (react-scripts@4.0.3), the build fails with: ./node_modules/@amplitude/plugin-web-vitals-browser/node_modules/web-vitals/dist/web-vitals.js<br /><br />SyntaxError:…
Question about Amplitude Export API Data Delay
Hello, I'm using SpringBoot and Kotlin to integrate with the Amplitude Export API. The official Amplitude documentation (https://amplitude.com/docs/apis/analytics/export) states that "data is available to export at a minimum within 2 hours of when the servers received it." However, there's no clear information about the…