#SQL
23 articles with this tag
Databricks Simplifies SQL ETL in Lakehouse
Databricks enhances its Lakehouse platform with declarative patterns for SQL ETL, simplifying append, CDC, and batch updates for data analysts.
Databricks IDE Integration Boosts Dev Productivity
Databricks enhances developer productivity by enabling local IDE integration for running and debugging workloads directly on its platform.
Databricks SQL Migration Myths Busted
Databricks SQL scripting now allows direct 'lift-and-shift' migration of complex legacy stored procedures, slashing timelines and empowering SQL teams.
Databricks AI Functions Arrive
Databricks integrates AI models into SQL queries with new AI Functions, simplifying data analysis and reducing complexity for users.
Databricks Acquires Electric
Databricks acquires Electric, integrating WASM Postgres (PGlite) and real-time sync for enhanced AI agent sandboxes.
Databricks Tries AI to Tame SQL Migrations
Databricks' new AI agent, Genie Code, automates T-SQL and other proprietary SQL to ANSI SQL migrations, simplifying data warehouse transitions.
Databricks Bets on AI for SQL Code Conversion
Databricks rolls out its AI-powered agentic code converter beta, aiming to simplify proprietary SQL to ANSI SQL conversions for data warehouse migrations.
Synapse to Databricks: The Migration Playbook
Moving from Azure Synapse to Databricks offers a unified Lakehouse, streamlining analytics and AI workloads while cutting costs and complexity.
Abed Matini on Hybrid RAG, SQL, and UI Telemetry
Abed Matini from Ogilvy discusses hybrid RAG, SQL, and UI telemetry for efficient document chatbots, highlighting challenges and solutions.
Databricks RLS Explained
Databricks row-level security filters data at the database level, enhancing multi-tenant SaaS, compliance, and data segregation.
Databricks Adds Query Context
Databricks Query Tags add vital context to data warehouse operations, enabling better cost attribution and workload monitoring for teams and applications.
Liquid Clustering Replaces Partitioning
Databricks' Liquid Clustering is replacing traditional partitioning, offering major performance gains and debunking myths about data layout.
Databricks BI Stack: Faster Queries, Lower Costs
Databricks unveils its BI serving stack, integrating physical data optimization with a governed semantic layer for enhanced performance and reduced costs.
Databricks Launches Analytics Engineer Path
Databricks launches a new learning pathway for SQL practitioners to become analytics engineers, covering data modeling, pipelines, and AI agent deployment.
Databricks Driver Gets Faster, Feature-Rich
Databricks rolls out its open-source JDBC driver with significant speed boosts and new features for enhanced data connectivity.
Databricks Speeds Up Analytics with Sketch Functions
Databricks enhances analytics with new sketch functions, delivering orders-of-magnitude speedups for percentile, distinct count, and top-K queries.
LLM Agents Tackle Database Joins
Databricks tests LLM agents for SQL join order optimization, achieving significant performance gains over traditional methods.
Databricks Excel Add-in Simplifies Data Access
Databricks launches an Excel Add-in, allowing business users governed access to lakehouse data without SQL, simplifying analysis and ensuring data consistency.
Databricks Connects to Google Sheets
Databricks introduces a Google Sheets connector, bringing real-time, governed Lakehouse data directly into spreadsheets for enhanced business analysis.
Cloud Databases: The New Infrastructure
Cloud-based database management systems offer scalability and efficiency by leveraging cloud infrastructure, but require careful consideration of costs and vendor lock-in.
Relational Data Model: The Backbone of Databases
The relational data model organizes data into tables, ensuring integrity and enabling efficient querying with SQL. It's the foundation of many databases but faces challenges with unstructured data.
Databricks Streamlines Lakehouse Migrations
Databricks updates Lakebridge with AI-powered SQL conversion and enhanced assessment tools to simplify data warehouse migrations.
