View Source

IoT Bridge for Snowflake v2.0.0 - June 09, 2025

Added support non-Sparkplug MQTT ingest into Snowflake
Added support for non-UDT Ignition tag data
Added support for edge node level UDTs/tags
Added support for nested UDTs
Added IoT Bridge Setup Assistant native application to Snowflake Marketplace
Added global 'templates' schema and views for visibility across all Sparkplug edge nodes

IoT Bridge for Snowflake v1.0.3 - February 15, 2024

Updated YAJSW to v13.11
Updated Ubuntu to 20.04 LTS and 22.04 LTS for Azure and AWS respectively
Improved logging around Sparkplug encoding
Updated Apache Commons Config2 dependency to 2.9.0

IoT Bridge for Snowflake v1.0.2 - November 21, 2023

Added info/metric tracking for diagnostics
Added support for private key file handling to simplify configuration
Improved 'synch handling' to streamline stored procedure calls and added retry support
Added 'subscription filtering' to support subscribing to only subsets of Sparkplug data
Added support for multiple MQTT Server connections from IoT Bridge
Improvements to default configuration files
Fixed support for Sparkplug 3.0.0 STATE messages
Fixed 'verify hostname' suppport for TLS connections
Third Party Software Notice
- Apache Commons - commons-beanutils
  - Website: https://github.com/apache/commons-beanutils
  - License: Apache License v2.0: https://github.com/apache/commons-beanutils/blob/master/LICENSE.txt
  - Copyright: © 2000-2019 The Apache Software Foundation
- Apache Commons - commons-codec
  - Website: https://commons.apache.org/
  - License: Apache License v2.0: https://github.com/apache/commons-codec/blob/master/LICENSE.txt
  - Copyright: © 2001-2020 The Apache Software Foundation. All Rights Reserved.
- Apache Commons - commons-collections
  - Website: https://github.com/apache/commons-collections
  - License: Apache License v2.0: https://github.com/apache/commons-collections/blob/master/LICENSE.txt
  - Copyright: © 2001-2020 The Apache Software Foundation
- Apache Commons - commons-compress
  - Website: https://github.com/apache/commons-compress
  - License: Apache License v2.0: https://github.com/apache/commons-compress/blob/master/LICENSE.txt
  - Copyright: © 2002-2020 The Apache Software Foundation
- Apache Commons - commons-configuration2
  - Website: https://commons.apache.org/proper/commons-configuration/index.html
  - License: Apache License v2.0: https://github.com/apache/commons-configuration/blob/master/LICENSE.txt
  - Copyright: © 2001-2020 The Apache Software Foundation
- Apache Commons - commons-io
  - Website: https://github.com/apache/commons-io
  - License: Apache License v2.0: https://github.com/apache/commons-io/blob/master/LICENSE.txt
  - Copyright: © 2002-2020 The Apache Software Foundation
- Apache Commons - commons-lang3
  - Website: https://github.com/apache/commons-lang
  - License: Apache License v2.0: https://github.com/apache/commons-lang/blob/master/LICENSE.txt
  - Copyright: © 2001-2020 The Apache Software Foundation
- Apache Commons - commons-logging
  - Website: https://github.com/apache/commons-logging
  - License: Apache License v2.0: https://github.com/apache/commons-logging/blob/master/LICENSE.txt
  - Copyright: © 2003-2016 The Apache Software Foundation
- Apache Commons - commons-text
  - Website: https://github.com/apache/commons-text
  - License: Apache License v2.0: https://github.com/apache/commons-text/blob/master/LICENSE.txt
  - Copyright: © 2001-2020 The Apache Software Foundation
- Apache HTTP Components (httpclient, httpcore, httpmime, httpclient-cache, fluent-hc)
  - Website: http://hc.apache.org/
  - License: Apache License v2.0: https://hc.apache.org/httpclient-3.x/license.html
  - Copyright: © 2001-2020 The Apache Software Foundation. All Rights Reserved.
- Amazon AWS SDK Core
  - Website: https://github.com/aws/aws-sdk-java/tree/master/aws-java-sdk-core
  - License: Apache License v2.0: https://github.com/aws/aws-sdk-java/blob/master/LICENSE.txt
  - Copyright: © 2016-2023 Amazon.com, Inc. or its affiliates. All Rights Reserved.
- Amazon Ion-java
  - Website: https://github.com/amzn/ion-java
  - License: Apache License v2.0: https://github.com/amzn/ion-java/blob/master/LICENSE
  - Copyright: © 2007-2019 Amazon.com, Inc. or its affiliates. All Rights Reserved.
- BouncyCastle
  - Website: https://www.bouncycastle.org
  - License: https://www.bouncycastle.org/license.html
  - Copyright: © 2000-2020 The Legion of the Bouncy Castle Inc. (https://www.bouncycastle.org)
- Eclipse Paho Client
  - Website: https://www.eclipse.org/paho/
  - License: Eclipse Public License v1.0: https://projects.eclipse.org/projects/iot.paho
  - Copyright: © 2014 Eclipse Paho. All Rights Reserved.
- Eclipse Tahu
  - Website: https://github.com/eclipse/tahu
  - License: Eclipse Publc License v2.0: https://github.com/eclipse/tahu/blob/master/LICENCE
  - Copyright: © 2014-2020 Cirrus Link Solutions and others
- Google Conscypt
  - Website: https://github.com/google/conscrypt
  - License: Apache License v2.0: https://github.com/google/conscrypt/blob/master/LICENSE
  - Copyright: © 2016 The Android Open Source Project
- Google Gson
  - Website: https://github.com/google/gson
  - License: Apache License v2.0: https://github.com/google/gson/blob/master/LICENSE
  - Copyright: © 2008 Google Inc.
- Google Protocol Buffers - protobuf-java
  - Website: https://github.com/protocolbuffers/protobuf
  - License: https://github.com/protocolbuffers/protobuf/blob/master/LICENSE
  - Copyright: © 2008 Google Inc. All rights reserved.
- Jackson FasterXML
  - jackson-annotations
    - Website: https://github.com/FasterXML/jackson-annotations
    - License: Apache License v2.0: https://github.com/FasterXML/jackson-annotations/blob/master/LICENSE
    - Copyright: © 2013, FasterXML, LLC, Seattle, USA
  - jackson-core
    - Website: https://github.com/FasterXML/jackson-core
    - License: Apache License v2.0: https://github.com/FasterXML/jackson-core/blob/master/LICENSE
    - Copyright: © 2013, FasterXML, LLC, Seattle, USA
  - jackson-databind
    - Website: https://github.com/FasterXML/jackson-databind
    - License: Apache License v2.0: https://github.com/FasterXML/jackson-databind/blob/master/LICENSE
    - Copyright: © 2013, FasterXML, LLC, Seattle, USA
  - jackson-dataformat-cbor
    - Website: https://github.com/FasterXML/jackson-dataformats-binary
    - License: Apache License v2.0: https://github.com/FasterXML/jackson-dataformats-binary#license
    - Copyright: © 2013, FasterXML, LLC, Seattle, USA
- Joda Time
  - Website: https://github.com/JodaOrg/joda-time
  - License: Apache v2.0: https://github.com/JodaOrg/joda-time/blob/master/LICENSE.txt
  - Copyright: © 2001-2019 Stephen Colebourne
- Junixsocket
  - Website: https://github.com/kohlschutter/junixsocket
  - License: Apache v2.0: https://github.com/kohlschutter/junixsocket/blob/main/LICENSE
  - Copyright: © 2009-2022 Christian Kohlschütter
- Logback
  - Website: http://logback.qos.ch/
  - License: Eclipse Public License v1.0: http://logback.qos.ch/license.html
  - Copyright: © 1999-2017, QOS.ch
- Snowflake Ingest
  - Website: https://github.com/snowflakedb/snowflake-ingest-java
  - License: Apache v2.0: https://github.com/snowflakedb/snowflake-ingest-java/blob/master/LICENSE
  - Copyright: © 2012-2017 Snowflake Computing Inc. All rights reserved.
- SLF4J
  - Website: http://www.slf4j.org/
  - License: MIT: http://www.slf4j.org/license.html
  - Copyright: © 2004-2015 QOS.ch

IoT Bridge for Snowflake v1.0.1 - June 22, 2023

Added support for Azure Marketplace
Expanded the channel creation schemes to support more channels
Updated the Snowflake streaming API
Third Party Software Notice
- Apache Commons - commons-beanutils
  - Website: https://github.com/apache/commons-beanutils
  - License: Apache License v2.0: https://github.com/apache/commons-beanutils/blob/master/LICENSE.txt
  - Copyright: © 2000-2019 The Apache Software Foundation
- Apache Commons - commons-codec
  - Website: https://commons.apache.org/
  - License: Apache License v2.0: https://github.com/apache/commons-codec/blob/master/LICENSE.txt
  - Copyright: © 2001-2020 The Apache Software Foundation. All Rights Reserved.
- Apache Commons - commons-collections
  - Website: https://github.com/apache/commons-collections
  - License: Apache License v2.0: https://github.com/apache/commons-collections/blob/master/LICENSE.txt
  - Copyright: © 2001-2020 The Apache Software Foundation
- Apache Commons - commons-compress
  - Website: https://github.com/apache/commons-compress
  - License: Apache License v2.0: https://github.com/apache/commons-compress/blob/master/LICENSE.txt
  - Copyright: © 2002-2020 The Apache Software Foundation
- Apache Commons - commons-configuration2
  - Website: https://commons.apache.org/proper/commons-configuration/index.html
  - License: Apache License v2.0: https://github.com/apache/commons-configuration/blob/master/LICENSE.txt
  - Copyright: © 2001-2020 The Apache Software Foundation
- Apache Commons - commons-io
  - Website: https://github.com/apache/commons-io
  - License: Apache License v2.0: https://github.com/apache/commons-io/blob/master/LICENSE.txt
  - Copyright: © 2002-2020 The Apache Software Foundation
- Apache Commons - commons-lang3
  - Website: https://github.com/apache/commons-lang
  - License: Apache License v2.0: https://github.com/apache/commons-lang/blob/master/LICENSE.txt
  - Copyright: © 2001-2020 The Apache Software Foundation
- Apache Commons - commons-logging
  - Website: https://github.com/apache/commons-logging
  - License: Apache License v2.0: https://github.com/apache/commons-logging/blob/master/LICENSE.txt
  - Copyright: © 2003-2016 The Apache Software Foundation
- Apache Commons - commons-text
  - Website: https://github.com/apache/commons-text
  - License: Apache License v2.0: https://github.com/apache/commons-text/blob/master/LICENSE.txt
  - Copyright: © 2001-2020 The Apache Software Foundation
- Apache HTTP Components (httpclient, httpcore, httpmime, httpclient-cache, fluent-hc)
  - Website: http://hc.apache.org/
  - License: Apache License v2.0: https://hc.apache.org/httpclient-3.x/license.html
  - Copyright: © 2001-2020 The Apache Software Foundation. All Rights Reserved.
- Amazon AWS SDK Core
  - Website: https://github.com/aws/aws-sdk-java/tree/master/aws-java-sdk-core
  - License: Apache License v2.0: https://github.com/aws/aws-sdk-java/blob/master/LICENSE.txt
  - Copyright: © 2016-2023 Amazon.com, Inc. or its affiliates. All Rights Reserved.
- Amazon Ion-java
  - Website: https://github.com/amzn/ion-java
  - License: Apache License v2.0: https://github.com/amzn/ion-java/blob/master/LICENSE
  - Copyright: © 2007-2019 Amazon.com, Inc. or its affiliates. All Rights Reserved.
- BouncyCastle
  - Website: https://www.bouncycastle.org
  - License: https://www.bouncycastle.org/license.html
  - Copyright: © 2000-2020 The Legion of the Bouncy Castle Inc. (https://www.bouncycastle.org)
- Eclipse Paho Client
  - Website: https://www.eclipse.org/paho/
  - License: Eclipse Public License v1.0: https://projects.eclipse.org/projects/iot.paho
  - Copyright: © 2014 Eclipse Paho. All Rights Reserved.
- Eclipse Tahu
  - Website: https://github.com/eclipse/tahu
  - License: Eclipse Publc License v2.0: https://github.com/eclipse/tahu/blob/master/LICENCE
  - Copyright: © 2014-2020 Cirrus Link Solutions and others
- Google Conscypt
  - Website: https://github.com/google/conscrypt
  - License: Apache License v2.0: https://github.com/google/conscrypt/blob/master/LICENSE
  - Copyright: © 2016 The Android Open Source Project
- Google Gson
  - Website: https://github.com/google/gson
  - License: Apache License v2.0: https://github.com/google/gson/blob/master/LICENSE
  - Copyright: © 2008 Google Inc.
- Google Protocol Buffers - protobuf-java
  - Website: https://github.com/protocolbuffers/protobuf
  - License: https://github.com/protocolbuffers/protobuf/blob/master/LICENSE
  - Copyright: © 2008 Google Inc. All rights reserved.
- Jackson FasterXML
  - jackson-annotations
    - Website: https://github.com/FasterXML/jackson-annotations
    - License: Apache License v2.0: https://github.com/FasterXML/jackson-annotations/blob/master/LICENSE
    - Copyright: © 2013, FasterXML, LLC, Seattle, USA
  - jackson-core
    - Website: https://github.com/FasterXML/jackson-core
    - License: Apache License v2.0: https://github.com/FasterXML/jackson-core/blob/master/LICENSE
    - Copyright: © 2013, FasterXML, LLC, Seattle, USA
  - jackson-databind
    - Website: https://github.com/FasterXML/jackson-databind
    - License: Apache License v2.0: https://github.com/FasterXML/jackson-databind/blob/master/LICENSE
    - Copyright: © 2013, FasterXML, LLC, Seattle, USA
  - jackson-dataformat-cbor
    - Website: https://github.com/FasterXML/jackson-dataformats-binary
    - License: Apache License v2.0: https://github.com/FasterXML/jackson-dataformats-binary#license
    - Copyright: © 2013, FasterXML, LLC, Seattle, USA
- Joda Time
  - Website: https://github.com/JodaOrg/joda-time
  - License: Apache v2.0: https://github.com/JodaOrg/joda-time/blob/master/LICENSE.txt
  - Copyright: © 2001-2019 Stephen Colebourne
- Junixsocket
  - Website: https://github.com/kohlschutter/junixsocket
  - License: Apache v2.0: https://github.com/kohlschutter/junixsocket/blob/main/LICENSE
  - Copyright: © 2009-2022 Christian Kohlschütter
- Logback
  - Website: http://logback.qos.ch/
  - License: Eclipse Public License v1.0: http://logback.qos.ch/license.html
  - Copyright: © 1999-2017, QOS.ch
- Snowflake Ingest
  - Website: https://github.com/snowflakedb/snowflake-ingest-java
  - License: Apache v2.0: https://github.com/snowflakedb/snowflake-ingest-java/blob/master/LICENSE
  - Copyright: © 2012-2017 Snowflake Computing Inc. All rights reserved.
- SLF4J
  - Website: http://www.slf4j.org/
  - License: MIT: http://www.slf4j.org/license.html
  - Copyright: © 2004-2015 QOS.ch

IoT Bridge for Snowflake v1.0.0 - April 21, 2023

Initial release
Third Party Software Notice
- Apache Commons - commons-beanutils
  - Website: https://github.com/apache/commons-beanutils
  - License: Apache License v2.0: https://github.com/apache/commons-beanutils/blob/master/LICENSE.txt
  - Copyright: © 2000-2019 The Apache Software Foundation
- Apache Commons - commons-codec
  - Website: https://commons.apache.org/
  - License: Apache License v2.0: https://github.com/apache/commons-codec/blob/master/LICENSE.txt
  - Copyright: © 2001-2020 The Apache Software Foundation. All Rights Reserved.
- Apache Commons - commons-collections
  - Website: https://github.com/apache/commons-collections
  - License: Apache License v2.0: https://github.com/apache/commons-collections/blob/master/LICENSE.txt
  - Copyright: © 2001-2020 The Apache Software Foundation
- Apache Commons - commons-compress
  - Website: https://github.com/apache/commons-compress
  - License: Apache License v2.0: https://github.com/apache/commons-compress/blob/master/LICENSE.txt
  - Copyright: © 2002-2020 The Apache Software Foundation
- Apache Commons - commons-configuration2
  - Website: https://commons.apache.org/proper/commons-configuration/index.html
  - License: Apache License v2.0: https://github.com/apache/commons-configuration/blob/master/LICENSE.txt
  - Copyright: © 2001-2020 The Apache Software Foundation
- Apache Commons - commons-io
  - Website: https://github.com/apache/commons-io
  - License: Apache License v2.0: https://github.com/apache/commons-io/blob/master/LICENSE.txt
  - Copyright: © 2002-2020 The Apache Software Foundation
- Apache Commons - commons-lang3
  - Website: https://github.com/apache/commons-lang
  - License: Apache License v2.0: https://github.com/apache/commons-lang/blob/master/LICENSE.txt
  - Copyright: © 2001-2020 The Apache Software Foundation
- Apache Commons - commons-logging
  - Website: https://github.com/apache/commons-logging
  - License: Apache License v2.0: https://github.com/apache/commons-logging/blob/master/LICENSE.txt
  - Copyright: © 2003-2016 The Apache Software Foundation
- Apache Commons - commons-text
  - Website: https://github.com/apache/commons-text
  - License: Apache License v2.0: https://github.com/apache/commons-text/blob/master/LICENSE.txt
  - Copyright: © 2001-2020 The Apache Software Foundation
- Apache HTTP Components (httpclient, httpcore, httpmime, httpclient-cache, fluent-hc)
  - Website: http://hc.apache.org/
  - License: Apache License v2.0: https://hc.apache.org/httpclient-3.x/license.html
  - Copyright: © 2001-2020 The Apache Software Foundation. All Rights Reserved.
- Amazon AWS SDK Core
  - Website: https://github.com/aws/aws-sdk-java/tree/master/aws-java-sdk-core
  - License: Apache License v2.0: https://github.com/aws/aws-sdk-java/blob/master/LICENSE.txt
  - Copyright: © 2016-2023 Amazon.com, Inc. or its affiliates. All Rights Reserved.
- Amazon Ion-java
  - Website: https://github.com/amzn/ion-java
  - License: Apache License v2.0: https://github.com/amzn/ion-java/blob/master/LICENSE
  - Copyright: © 2007-2019 Amazon.com, Inc. or its affiliates. All Rights Reserved.
- BouncyCastle
  - Website: https://www.bouncycastle.org
  - License: https://www.bouncycastle.org/license.html
  - Copyright: © 2000-2020 The Legion of the Bouncy Castle Inc. (https://www.bouncycastle.org)
- Eclipse Paho Client
  - Website: https://www.eclipse.org/paho/
  - License: Eclipse Public License v1.0: https://projects.eclipse.org/projects/iot.paho
  - Copyright: © 2014 Eclipse Paho. All Rights Reserved.
- Eclipse Tahu
  - Website: https://github.com/eclipse/tahu
  - License: Eclipse Publc License v2.0: https://github.com/eclipse/tahu/blob/master/LICENCE
  - Copyright: © 2014-2020 Cirrus Link Solutions and others
- Google Conscypt
  - Website: https://github.com/google/conscrypt
  - License: Apache License v2.0: https://github.com/google/conscrypt/blob/master/LICENSE
  - Copyright: © 2016 The Android Open Source Project
- Google Gson
  - Website: https://github.com/google/gson
  - License: Apache License v2.0: https://github.com/google/gson/blob/master/LICENSE
  - Copyright: © 2008 Google Inc.
- Google Protocol Buffers - protobuf-java
  - Website: https://github.com/protocolbuffers/protobuf
  - License: https://github.com/protocolbuffers/protobuf/blob/master/LICENSE
  - Copyright: © 2008 Google Inc. All rights reserved.
- Jackson FasterXML
  - jackson-annotations
    - Website: https://github.com/FasterXML/jackson-annotations
    - License: Apache License v2.0: https://github.com/FasterXML/jackson-annotations/blob/master/LICENSE
    - Copyright: © 2013, FasterXML, LLC, Seattle, USA
  - jackson-core
    - Website: https://github.com/FasterXML/jackson-core
    - License: Apache License v2.0: https://github.com/FasterXML/jackson-core/blob/master/LICENSE
    - Copyright: © 2013, FasterXML, LLC, Seattle, USA
  - jackson-databind
    - Website: https://github.com/FasterXML/jackson-databind
    - License: Apache License v2.0: https://github.com/FasterXML/jackson-databind/blob/master/LICENSE
    - Copyright: © 2013, FasterXML, LLC, Seattle, USA
  - jackson-dataformat-cbor
    - Website: https://github.com/FasterXML/jackson-dataformats-binary
    - License: Apache License v2.0: https://github.com/FasterXML/jackson-dataformats-binary#license
    - Copyright: © 2013, FasterXML, LLC, Seattle, USA
- Joda Time
  - Website: https://github.com/JodaOrg/joda-time
  - License: Apache v2.0: https://github.com/JodaOrg/joda-time/blob/master/LICENSE.txt
  - Copyright: © 2001-2019 Stephen Colebourne
- Junixsocket
  - Website: https://github.com/kohlschutter/junixsocket
  - License: Apache v2.0: https://github.com/kohlschutter/junixsocket/blob/main/LICENSE
  - Copyright: © 2009-2022 Christian Kohlschütter
- Logback
  - Website: http://logback.qos.ch/
  - License: Eclipse Public License v1.0: http://logback.qos.ch/license.html
  - Copyright: © 1999-2017, QOS.ch
- Snowflake Ingest
  - Website: https://github.com/snowflakedb/snowflake-ingest-java
  - License: Apache v2.0: https://github.com/snowflakedb/snowflake-ingest-java/blob/master/LICENSE
  - Copyright: © 2012-2017 Snowflake Computing Inc. All rights reserved.
- SLF4J
  - Website: http://www.slf4j.org/
  - License: MIT: http://www.slf4j.org/license.html
  - Copyright: © 2004-2015 QOS.ch