BigQuery Data Insights Enhance Data Exploration

Google Cloud highlighted BigQuery's new data insights capabilities at Next '24, presenting relevant, click-to-run table searches

[{"selector":"#anim-f676b7d9-afa6-44d1-b7d0-fdbe7dade5ff","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6330a9da-6d24-453d-952f-dc3b2c7f9de1","keyframes":{"transform":["translate3d(-116.00001%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2dee2780-c52c-4c89-80a0-03e65f6d6f3e [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(35.234374910402764%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}]

Data Insights leverages database metadata with Google's Gemini models to find hidden patterns in tables

[{"selector":"#anim-6f60a45b-c966-4f68-9d7e-444727e6f904","keyframes":{"transform":["translate3d(116.00001%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .8, 1)","fill":"both"}] [{"selector":"#anim-0640f6af-f3e0-40f6-ac9c-43960d749d8b","keyframes":{"transform":["rotateZ(180deg)","rotateZ(0deg)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .5, 1)","fill":"forwards"}] [{"selector":"#anim-cadc2c64-1657-4e96-8943-46ee2fdd68b9 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-34.177098578508605%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}]

It creates queries based on dataset patterns and data distribution using profile scan data

[{"selector":"#anim-760e1982-3a2e-4dd9-8dc7-03914c32c814","keyframes":{"transform":["translate3d(-118.48184%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cbf44c6d-26b7-48cb-ba38-9590ea8ffce4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3abf2a9c-4948-4f66-98f8-e351523197b5","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-a57beda5-b177-4919-a819-551f75acf36b [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-33.68749990101638%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}]

Business analysts, data scientists, and other non-technical users use BigQuery data insights to make smart decisions

[{"selector":"#anim-9f299c26-941b-4c69-b9e9-68d1de1865b2","keyframes":{"opacity":[1,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-35455240-967c-4d08-93cd-94ebe831f780","keyframes":{"transform":["scale(3)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-3cbb7816-f0e0-4069-96f5-8a0084691206 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-25.812499853231184%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}]

To obtain insights from your data, go to the BigQuery Studio in the Google Cloud dashboard after your data is in BigQuery

[{"selector":"#anim-c0b09a66-901a-4b9e-b656-d7966be1a8c7 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-54.101562372003954%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] [{"selector":"#anim-15c49ada-e488-40f1-addd-083527be7027","keyframes":{"transform":["scale(1)","scale(1.5)","scale(0.95)","scale(1)"],"offset":[0,0.33,0.66,1]},"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}]

Data Insights automatically generated metadata-based queries to let Alex explore new tables faster

[{"selector":"#anim-ff762158-be47-4eaf-aeff-9a08a9499001","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-46796436-de5d-49bb-81cf-cb44357f8b18","keyframes":{"transform":["translate3d(0px, 125.24563%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4866728a-d624-4524-ba2e-a836dad9d6a3 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-1.9531248720039565%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}]

Data insights made data analysis accessible to non-technical people, fostering teamwork and uniform data interpretation

[{"selector":"#anim-e7997707-d990-4cab-9228-2c00709428d7","keyframes":{"opacity":[1,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-84d80280-2902-4358-94f2-0a5ce391bf1c","keyframes":{"transform":["scale(3)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-ba72f6ef-c0f8-4b57-81e5-eb63b3652187 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-62.49999977245145%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}]

It facilitates data exploration and frees up data professionals to work on harder tasks by using table metadata For more details govindhtech.com

[{"selector":"#anim-3f79b06c-cd70-4ba5-977a-712a9584c671","keyframes":{"transform":["translate3d(107.54717%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cbd2bbf6-1588-4185-ae3b-128d94eefeeb","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fa1d7fec-aefd-4e2c-add0-18a4ec6ffceb","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-82b4f926-8617-4c80-abbf-809b3936d6c3 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-31.249999886225726%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}]