{"id":44405,"date":"2020-11-19T04:41:00","date_gmt":"2020-11-19T09:41:00","guid":{"rendered":"http:\/\/blog.cybercon1.com\/?p=44405"},"modified":"2020-11-19T04:41:00","modified_gmt":"2020-11-19T09:41:00","slug":"databricks-launches-sql-analytics","status":"publish","type":"post","link":"https:\/\/blog.cyberconservices.com\/index.php\/2020\/11\/19\/databricks-launches-sql-analytics\/","title":{"rendered":"Databricks launches SQL Analytics"},"content":{"rendered":"\n

By Frederic Lardinois<\/a> – AI and data analytics<\/strong> company\u00a0Databricks<\/a>\u00a0today announced the launch of SQL Analytics<\/strong>, a new service that makes it easier for data <\/strong>analysts to run their standard SQL queries directly on data lakes. And with that, enterprises can now easily connect their business intelligence tools like Tableau and Microsoft\u2019s Power BI<\/strong> to these data repositories as well.<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

SQL Analytics will be available in public preview on November 18.<\/p>\n\n\n\n

In many ways, SQL Analytics is the product\u00a0Databricks\u00a0<\/a>\u00a0has long been looking to build and that brings its concept of a \u201clake house\u201d to life. It combines the performance of a data<\/strong> warehouse, where you store data <\/strong>after it has already been transformed and cleaned, with a data <\/strong>lake, where you store all of your data i<\/strong>n its raw form. The data i<\/strong>n the data <\/strong>lake, a concept that Databricks\u2019 co-founder and CEO\u00a0Ali Ghodsi\u00a0<\/a>\u00a0has\u00a0long championed<\/a>, is typically only transformed when it gets used. That makes data l<\/strong>akes cheaper, but also a bit harder to handle for users.<\/p>\n\n\n\n

\u201cWe\u2019ve been saying Unified Data Analytics<\/strong>, which means unify the data with the analytics. So data<\/strong> processing and analytics, those two should be merged. But no one picked that up,\u201d Ghodsi told me. But \u201clake house\u201d caught on as a term.<\/p>\n\n\n\n

\u201cDatabricks has always offered data science, machine learning. We\u2019ve talked about that for years. And with Spark, we provide the data processing capability. You can do [extract, transform, load]. That has always been possible. SQL Analytics enables you to now do the data warehousing workloads directly, and concretely, the business intelligence and reporting workloads, directly on the data<\/strong> lake.\u201d Read On:<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

By Frederic Lardinois – AI and data analytics company\u00a0Databricks\u00a0today announced the launch of SQL Analytics, a new service that makes it easier for data analysts to run their standard SQL queries directly on data lakes. And with that, enterprises can …<\/span> Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[651,83,644],"tags":[195,251,645],"class_list":["post-44405","post","type-post","status-publish","format-standard","hentry","category-analytics-data","category-data","category-power-bi","tag-analytics","tag-data","tag-power-bi"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":46533,"url":"https:\/\/blog.cyberconservices.com\/index.php\/2022\/03\/11\/power-bi-platform-adds-new-data-prep-mobile-capabilities\/","url_meta":{"origin":44405,"position":0},"title":"Power BI platform adds new data prep, mobile capabilities","author":"Rick Backus","date":"March 11, 2022","format":false,"excerpt":"Among them, Dynamic M Query Parameters to support SQL Server has the potential to be particularly useful to Power BI platform users, according to Doug Henschen, an analyst at Constellation Research. Dynamic M Query Parameters is\u00a0a data preparation tool\u00a0that enables Power BI users to specify the parameters of a query\u2026","rel":"","context":"In "Power BI"","block_context":{"text":"Power BI","link":"https:\/\/blog.cyberconservices.com\/index.php\/category\/power-bi\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":31852,"url":"https:\/\/blog.cyberconservices.com\/index.php\/2019\/09\/06\/sql-server-2019-reporting-services-rc1-now-available\/","url_meta":{"origin":44405,"position":1},"title":"SQL Server 2019 Reporting Services RC1 now available","author":"Rick Backus","date":"September 6, 2019","format":false,"excerpt":"Last year,\u00a0Microsoft announced SQL Server 2019, its new database management system (DBMS) that helps manage both relational and non-relational databases through a common service. It runs on-premise, in the cloud, and on Azure Stack as well. Today, the Redmond firm has\u00a0announced that the first release candidate (RC1) for SQL Server\u2026","rel":"","context":"In "Big Data"","block_context":{"text":"Big Data","link":"https:\/\/blog.cyberconservices.com\/index.php\/category\/big-data\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.cyberconservices.com\/wp-content\/uploads\/2019\/09\/sql-server-2019.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":44932,"url":"https:\/\/blog.cyberconservices.com\/index.php\/2021\/03\/11\/microsoft-power-bi-premium-new-platform-and-pricing-what-you-need-to-know\/","url_meta":{"origin":44405,"position":2},"title":"Microsoft Power BI Premium: New platform and pricing, what you need to know","author":"Rick Backus","date":"March 11, 2021","format":false,"excerpt":"This is a excellent tool. Bringing it closer to home would be great but was cost prohibitive. Apparently, not anymore with the new shared architecture. It used to cost $5,000 a month and run on dedicated hardware; now it's a $20 per user cloud service, which proves that a multi-tenant\u2026","rel":"","context":"In "Power BI"","block_context":{"text":"Power BI","link":"https:\/\/blog.cyberconservices.com\/index.php\/category\/power-bi\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.cyberconservices.com\/wp-content\/uploads\/2021\/03\/power-bi-premium-dashboard-tr.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.cyberconservices.com\/wp-content\/uploads\/2021\/03\/power-bi-premium-dashboard-tr.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.cyberconservices.com\/wp-content\/uploads\/2021\/03\/power-bi-premium-dashboard-tr.jpg?resize=525%2C300 1.5x"},"classes":[]},{"id":33183,"url":"https:\/\/blog.cyberconservices.com\/index.php\/2020\/02\/25\/tesla-pays-10k-for-microsoft-sql-server-reporting-services-bug\/","url_meta":{"origin":44405,"position":3},"title":"Tesla Pays $10K for Microsoft SQL Server Reporting Services Bug","author":"Rick Backus","date":"February 25, 2020","format":false,"excerpt":"By\u00a0Ionut Ilascu - Tesla paid a $10,000 bounty for a vulnerability in Microsoft SQL Server Reporting Services (SSRS) that had received a patch five days before getting the bug report. The issue was tagged as a server-side injection that led to remote code execution. German bug hunter\u00a0parzel\u00a0found it in a\u2026","rel":"","context":"In "SQL Server"","block_context":{"text":"SQL Server","link":"https:\/\/blog.cyberconservices.com\/index.php\/category\/sql-server\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cdn.pixabay.com\/photo\/2018\/09\/20\/09\/05\/assassin-3690300__340.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":31810,"url":"https:\/\/blog.cyberconservices.com\/index.php\/2019\/08\/08\/why-should-you-familiarise-yourself-with-power-bi\/","url_meta":{"origin":44405,"position":4},"title":"Why Should You Familiarise Yourself with Power BI","author":"Rick Backus","date":"August 8, 2019","format":false,"excerpt":"Microsoft Power BI is an application created by Microsoft to allow individuals or organisations to aggregate, analyse and visualise data that is easily understood. It is built for non-technical business users and has a simple user interface and easy to use tools. However, no matter how simple the interface is,\u2026","rel":"","context":"In "Power BI"","block_context":{"text":"Power BI","link":"https:\/\/blog.cyberconservices.com\/index.php\/category\/power-bi\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.cyberconservices.com\/wp-content\/uploads\/2019\/08\/brain-20424__340.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":34393,"url":"https:\/\/blog.cyberconservices.com\/index.php\/2020\/06\/22\/benefits-of-embedded-bi-and-customizable-analytics\/","url_meta":{"origin":44405,"position":5},"title":"Benefits of embedded BI and customizable analytics","author":"Rick Backus","date":"June 22, 2020","format":false,"excerpt":"Self-Service BI and Analytics is not just a nicety but a business necessity. Relying on statically constructed reporting that has to be rerun or worse, redesigned every time you need to \"ask the question in a different way\" is hurting your business. Leveraging BI tools gets you to the answers\u2026","rel":"","context":"In "BI"","block_context":{"text":"BI","link":"https:\/\/blog.cyberconservices.com\/index.php\/category\/bi\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/cdn.pixabay.com\/photo\/2016\/12\/13\/22\/15\/chart-1905225__340.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/cdn.pixabay.com\/photo\/2016\/12\/13\/22\/15\/chart-1905225__340.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/cdn.pixabay.com\/photo\/2016\/12\/13\/22\/15\/chart-1905225__340.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/cdn.pixabay.com\/photo\/2016\/12\/13\/22\/15\/chart-1905225__340.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blog.cyberconservices.com\/index.php\/wp-json\/wp\/v2\/posts\/44405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.cyberconservices.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.cyberconservices.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.cyberconservices.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.cyberconservices.com\/index.php\/wp-json\/wp\/v2\/comments?post=44405"}],"version-history":[{"count":0,"href":"https:\/\/blog.cyberconservices.com\/index.php\/wp-json\/wp\/v2\/posts\/44405\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.cyberconservices.com\/index.php\/wp-json\/wp\/v2\/media?parent=44405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.cyberconservices.com\/index.php\/wp-json\/wp\/v2\/categories?post=44405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.cyberconservices.com\/index.php\/wp-json\/wp\/v2\/tags?post=44405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}