Skip to content

Instantly share code, notes, and snippets.

@naren-dremio
Created October 6, 2020 16:56
Show Gist options
  • Save naren-dremio/c395989e92f9be8b68470901f02fa859 to your computer and use it in GitHub Desktop.
Save naren-dremio/c395989e92f9be8b68470901f02fa859 to your computer and use it in GitHub Desktop.
jdbcPort = 31010
jdbcDatabase = "DREMIO"
jdbcUsername = ""
jdbcPassword = ""
jdbcUrl = "jdbc:dremio:direct=<host>:31010"
connectionProperties = {
"user" : jdbcUsername,
"password" : jdbcPassword,
"driver" : "com.dremio.jdbc.Driver"
}
pushdown_query = "postgres.public.actor"
df = spark.read.jdbc(url=jdbcUrl, table=pushdown_query, properties=connectionProperties)
display(df)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment