# Snowflake to Elasticsearch Using Logtsash

**URL:** https://discuss.elastic.co/t/snowflake-to-elasticsearch-using-logtsash/341785
**Category:** Logstash
**Created:** [August 28, 2023, 7:33am UTC](https://discuss.elastic.co/t/snowflake-to-elasticsearch-using-logtsash/341785 "2023-08-28T07:33:25Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![ksaimohan2k](https://avatars.discourse-cdn.com/v4/letter/k/f4b2a3/32.png) [@ksaimohan2k](https://discuss.elastic.co/u/ksaimohan2k)
#### Post date: [August 28, 2023, 8:23am UTC](https://discuss.elastic.co/t/snowflake-to-elasticsearch-using-logtsash/341785/3 "2023-08-28T08:23:35Z")

</div>

Thanks @Rios for help

Tried the same as mentioned using the link you shared regarding [Logstash TimeZone](https://discuss.elastic.co/t/logstash-doesnt-work-in-windows-correctly-please-help/323161)

Here is the modified config file

```auto

input {
  jdbc {
    jdbc_driver_library => "C:\ELKStack\logstash-8.8.1-windows-x86_64\logstash-8.8.1\logstash-core\lib\jars\snowflake-jdbc-3.9.2-javadoc.jar"
    jdbc_driver_class => "com.snowflake.client.jdbc.SnowflakeDriver"
    jdbc_connection_string => "jdbc:snowflake:// *******.uae-north.azure.snowflakecomputing.com/?db=SNOWFLAKE_SAMPLE_DATA&warehouse=COMPUTE_WH"
    jdbc_user => "username"
    jdbc_password => "password"
    jdbc_default_timezone => "Asia/Dubai[dst_enabled_on_overlap:true]"
    schedule => "* * * * *"
    statement => "SELECT * FROM TPCH_SF1.CUSTOMER LIMIT 10;"
  }
}
filter
{}
output
{
  elasticsearch
  {
    hosts => ["http://localhost:9200"]
    user => "username"
    password => "password"
    index =>"snowflakelog_index"
  }
}

```

And executed the conf file using the command

`logstash.bat -f C:\ELKStack\logstash-8.8.1-windows-x86_64\logstash-8.8.1\config\conf.d\test.conf --path.settings C:\ELKStack\logstash-8.8.1-windows-x86_64\logstash-8.8.1\config `

But still the error remains the same

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/2/d2344533326cc821edf35e1ea5b3eb25639cbb4e.png)

---

_[View the full topic](https://discuss.elastic.co/t/snowflake-to-elasticsearch-using-logtsash/341785)._