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:

*Interzoid API License Key: Login or register to obtain

*Database Connection Type (Select from drop-down):

*Database Connection String (use full URL if CSV, such as "https://dl.interzoid.com/csv/zips.csv"): Sample connection strings

*Table Name ("CSV" if CSV):

*Zip Code Column Name (Column # if CSV, first column = 1):

Optional Reference Column Name (to include on report):

New Table Name (only if writing results back to database):

Select Report Type:

Weather by Zip Code Report (most users)

Generate Insert SQL Script for All Records

Create New Table in Source Database

* 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