Skip to main content

Advice and answers from the Openbridge Team

Search results for:R

How to fix 'Host key verification failed' SSH Error
-R {ssh.server.ip.address} ssh-keygen -R {ssh.server.ip.address} -f {/path/to/known_hosts} $ ssh-keygen… sed -i '/1.2.3.4/d' /home/ec2-user/.ssh/known_hosts Another option is to user ssh-keygen with the -R… If your remote hostname is server.openbridge.com ssh-keygen -R {server.openbridge.com} $ ssh-keygen
How To Easily Extract Data With Headers From Amazon Redshift
We created a service that wraps the Redshift UNLOAD command with some extra capabilities. This article explains how to run it… How To Run… Runtime parameters
How To Query Amazon Multi-market Accounts With Data Duplication
Standardizing `posted_date` CASE WHEN REGEXP_CONTAINS(T.posted_date, r'^\d{2}\.\d{2}\… standardized_posted_date, -- Standardizing `posted_date_time` CASE WHEN REGEXP_CONTAINS(T.posted_date_time, r'
How to Connect Tableau to Redshift
A Guide to create first Tableau visualization with data in Amazon Redshift… Your first visual in Tableau with the data from Redshift is ready! Enjoy the view!… How to connect Tableau to Amazon Redshift
How To Test Amazon Advertising Reporting Data
The Amazon Advertising reporting interface has different data than the API. Why?… Run a Reporting data export for Sponsored Products in the Amazon Advertising Reporting UI to do so… Configure and run a report export
Analytics-Ready: Freedom to Connect Your Data Tools
Delivering flexible, code-free analytics-ready data pipelines… Understanding the rapid rate of innovation is why we focus on open, standards-based architectures… data in Amazon Redshift, Amazon Redshift Spectrum, Google BigQuery, Azure Data Lake, Snowflake, or Amazon
How To Setup Amazon Redshift Spectrum Data Destination
This is the Amazon Web Service region that wants Amazon Redshift Spectrum configured… The IAM Role ARN allows us to call the AWS Redshift Spectrum services on your behalf… It will look like this arn:aws:iam::1223131231231:role/your-role-name
How To Submit A Support Request
First, please limit each request to one support item rather than a laundry list of questions and requests… When an original request asking for X shifts to questions or requests for Y or Z, responses will slow… We will generally respond within 24 hours of receiving a ticket
Product Development Requests
Framework for product development roadmaps… Before beta releases, Openbridge releases pilots of services… Requesting Product Development
How To Setup A Batch Data Pipeline For CSV Files To Redshift, Redshift Spectrum, Athena or BigQuery
Simple and easy bulk import of data to Amazon Redshift, Amazon Redshift Spectrum, Amazon Athena and BigQuery… like Amazon Redshift, Amazon Redshift Spectrum, Amazon Athena or Google BigQuery… They provide access to READ and WRITE access to data resident for your pipeline