Problem Using Cursor to Execute a Database Query

Question

I'm trying to do a query similar to this:

ctx = snowflake.connector.connect(
          host=host,
          user=user,
          password=password,
          account=account,
          warehouse=warehouse,
          database=database,
          schema=schema,
          protocol='https',
          port=port)

## Create a cursor object.
cur = ctx.cursor()

## Execute a statement that will generate a result set.
sql = "select * from t"
cur.execute(sql)

My query looks something like this:

select NUMBER, ID, DATE, CODE from DATABASE.SCHEMA.TABLE
where (cast(CODE as string) like 'ABC12%'
and (DATE < '2021-12-31' and DATE >= '2021-10-01')

I'm getting this error:

ProgrammingError: 001003 (42000): SQL compilation error:
syntax error line 3 at position 52 unexpected '<EOF>'.

I've looked up this error code and tried removing any special characters that might be there, but no luck.

Thanks in advance

you are missing one right parenthesis )

Maciej Wrobel
– Maciej Wrobel

2022-02-08 20:56:16 +00:00
Commented Feb 8, 2022 at 20:56 — Maciej Wrobel
– Maciej Wrobel, Commented Feb 8, 2022 at 20:56
You don't need the first ( in (cast(CODE as string)

Barmar
– Barmar

2022-02-08 20:57:14 +00:00
Commented Feb 8, 2022 at 20:57 — Barmar
– Barmar, Commented Feb 8, 2022 at 20:57
Wow I feel stupid. Thank you

Max
– Max

2022-02-08 21:06:27 +00:00
Commented Feb 8, 2022 at 21:06 — Max
– Max, Commented Feb 8, 2022 at 21:06

Simeon Pilgrim · Accepted Answer · 2022-02-08 21:08:00Z

1

If we re-format the SQL:

select 
    NUMBER, 
    ID, 
    DATE, 
    CODE 
from DATABASE.SCHEMA.TABLE
where (
    cast(CODE as string) like 'ABC12%'
    and (
        DATE < '2021-12-31' and DATE >= '2021-10-01'
        )

we can see you are missing the close bracket/paren to the WHERE clause.

But you don't actually need any brackets on this:

select 
    NUMBER, 
    ID, 
    DATE, 
    CODE 
from DATABASE.SCHEMA.TABLE
where CODE::text like 'ABC12%'
    and DATE < '2021-12-31' and DATE >= '2021-10-01'

answered Feb 8, 2022 at 21:08

Simeon Pilgrim

26.7k3 gold badges38 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Problem Using Cursor to Execute a Database Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related