Introducing our Snowflake Data Cloud Native Application: AI-Augmented Data Quality built into SQL statements! Learn More

Cloud Live Weather Append

This browser-based tool enables you to append live weather data to zip codes from database tables on major Cloud Data Platforms (or any other database that you can access via the Internet). Simply provide the connection string from your data source's database, table name, and column name(s). The Zip Column Name is the column for which the appended data will be applied. You can generate reports with the appended data in comma-delimited form, generate SQL Insert scripts, or write results to new tables in the source database through the connection.

For instructions on how to include live weather data as part of workflow, including scheduled runs, ongoing processing, or as part of a data pipeline, see the Live Weather Workflow Guide.


Run Here - Report Setup:


Login or register to obtain
Sample connection strings

Select Report Type:


* Note: Use connection type = "CSV File", connection string = "https://dl.interzoid.com/csv/zips.csv", table name = "CSV", and column name = "1" for a demo that does not use credits from your account.


Additional Information:


Login to www.interzoid.com to obtain your API Key. It is how we track usage. If you do not yet have one, register for a free trial at www.interzoid.com/register-api-account.

Sample SQL Scripts in case you need sample/test data for a test drive.

How to use CSV files for data processing within Interzoid Cloud Data Connect.

API used for Weather by Zip


            
        Weather by Zip Sample:
95476,Sonoma,CA,29.0,-1.7,Fair,... 59937,Whitefish,MT,41.0,5.0,Mostly Cloudy,... 96805,Honolulu,HI,76.0,24.4,Party Cloudy,... 74003,Bartlesville,OK,45.0,7.2,Fair,... 28801,Asheville,NC,50.0,10.0,Rain Fog/Mist,...

Run scheduled or as part of a batch script? Embed in workflow or within a data pipeline? Execute programmatically? You can run this entire process with a single API call. Example:

            
        https://connect.interzoid.com/run?function=weather&apikey=use-your-own-api-key-here&source=CSV&connection=https://dl.interzoid.com/csv/zips.csv&table=CSV&column=1&html=true
            


Full Dataset Processing API Documentation

Return to Platform Home