How do I convert DSOS SQL Database / DSW query into Python programming query?

@Uttam.Haridas

To run a SQL query in Python snowflake, you may need to use the Snowflake Connector for Python.

I found the following sample code on Google.

  import snowflake.connector


    # Establish connection

    conn = snowflake.connector.connect(

        user='your_user',

        password='your_password',

        account='your_account',

        warehouse='your_warehouse',

        database='your_database',

        schema='your_schema'

    )


    # Create a cursor object

    cur = conn.cursor()


    # Execute a SQL query

    cur.execute("SELECT * FROM your_table LIMIT 10")


    # Fetch results

    for row in cur:

        print(row)


    # Close cursor and connection

    cur.close()

    conn.close()

However, you need to contact the product team directly via LSEG Support to verify this.