Running and executing SQL & code cells

Introduction to DataLab

Jason Mak

Product lead

SQL and Code cells

SQL cells:

SQL cell

  • Execute database queries directly
  • Interact with structured data using SQL syntax
Code cells:

Python Code cell

  • Write and execute Python or R code
  • Perform calculations, data manipulation, and integrate with SQL results
Introduction to DataLab

Choosing a coding language

Language selector

Introduction to DataLab

Executing cells

Recipe example

Introduction to DataLab

Executing cells

Running cells example

Introduction to DataLab

Executing cells example

 

Cells run in order

Cells run in order

 

Cells run out of order

Cells run out of order

Introduction to DataLab

Monitoring execution

DataLab running cells

Introduction to DataLab

Key takeaways

 

 

  • SQL cells are used for database queries, while Code cells handle Python or R logic
  • Cells execute in order, building on outputs from previous cells
  • We can monitor execution using status indicators and queues
Introduction to DataLab

Let's practice!

Introduction to DataLab

Preparing Video For Download...