Databricks Community

This is what I'm trying to do using SQL: create table check1 asselect * from dataAwhere IDs in ('12483258','12483871','12483883'); The list of IDs is much longer and may be changed so I want to use a variable for that. This is what I have tried decla...

I want to create a widget in SQL and use it in R later. Below is my code%sqldeclare or replace date1 date = "2025-01-31";declare or replace date2 date ;set var date2=add_months(date1,5); What's the correct syntax of using date2 to create a widget? I ...