AI limitations

Introduction to SQL with AI

Jasmin Ludolf

Senior Data Science Content Developer

AI limitations

$$

  • AI assistants are helpful but not perfect

$$

  • Understanding limitations:
    • Write better prompts
    • Use AI effectively

Broken robot

Introduction to SQL with AI

AI limitations

Four limitations: schema knowledge gaps, data gaps, sql flavors, business context

Introduction to SQL with AI

AI limitation: schema

$$

  • AI assistants don't know the schema
    • Tables
    • Fields
    • Data types
    • Values
    • Relationships

Schema knowledge gap

Introduction to SQL with AI

Schema error

Prompt: Show me all customers from New York

SELECT city
FROM customers;

New york skyscraper and a map of the USA

Introduction to SQL with AI

AI limitation: data

$$

  • AI doesn't know if data is:
    • Repeated
    • Missing
    • Incorrect

Data gaps

Introduction to SQL with AI

AI limitation: data

Different date formats

Data gaps

Introduction to SQL with AI

AI limitation: data

Prompt: What countries are in the customers table?

Illustration of a summary document and the globe

Introduction to SQL with AI

AI limitation: SQL flavor

Confused AI robot

SQL flavors

Introduction to SQL with AI

AI: business context

$$

  • AI doesn't know business context

Christmas tree or sun

Business context

Introduction to SQL with AI

Our experience

$$

    Review code for errors                 Test on a small sample                  Verify the results Review, sample, verify

Introduction to SQL with AI

Iterative approach

Iterative conversation with AI

Introduction to SQL with AI

Be careful

$$

  • Be careful about information shared with AI assistants
  • Conversation history stored
  • Sensitive information could be exposed
  • Always consult policies or guidelines

warning.jpg

Introduction to SQL with AI

Let's practice!

Introduction to SQL with AI

Preparing Video For Download...