I have data that has an array of strings in documentdb. But when I dump to Redshift using glue the whole array is treated as a string. I know that there is no direct way of converting into an array in Redshift but is there any other way to do it?
Getting a String Instead of Array from Redshift while we dump data from DocumentDb to Redshift using Glue
472 views Asked by aditya Damera At
2
There are 2 answers
Related Questions in AMAZON-WEB-SERVICES
- S3 integration testing
- How to get content of BLOCK types LAYOUT_TITLE, LAYOUT_SECTION_HEADER and LAYOUT_xx in Textract
- Error **net::ERR_CONNECTION_RESET** error while uploading files to AWS S3 using multipart upload and Pre-Signed URL
- Failed to connect to your instance after deploying mern app on aws ec2 instance when i try to access frontend
- AWS - Tab Schema Conversion don't show up after creating a Migration Project
- Unable to run Bash Script using AWS Custom Lambda Runtime
- Using Amazon managed Prometheus to get EC2 metrics data in Grafana
- AWS Dns record A not navigate to elb
- Connection timed out error with smtp.gmail.com
- AWS Cognito Multi-tenant Integration | Ok to use Client’s Idp?
- Elasticbeanstalk FastAPI application is intermittently not responding to https requests
- Call an External API from AWS Lambda
- Why my mail service api spring isnt working?
- export 'AWSIoTProvider' (imported as 'AWSIoTProvider') was not found in '@aws-amplify/pubsub'
- How to take first x seconds of Audio from a wav file read from AWS S3 as binary stream using Python?
Related Questions in AMAZON-REDSHIFT
- Redshift/Postgres between function produces seemingly unrelated error when ">" or "<" both work but not together
- extract nested fields from dynamodb json format in redshift/ Unmarshall DynamoDB JSON to regular JSON
- Redshift Datashare and Python Flask backend with SQALAlchemy
- Qlik IntervalMatch to SQL
- Unable to connect to publicly accessible redshift cluster
- Loading around 50gb of parquet data to Redshift taking indefinite time to load
- Not equal vs IN in AWS Redshift
- Copy Command Redshift putting quotes around super column values
- Amazon RSQL concat of two tables with 2 shared columns
- SQL query to extract incremental data from a table in SQL Server
- Create table in Redshift through db_query() in Python
- latest version of redshift with crazy compile times
- redshift spectrum type conversion from String to Varchar
- Redshift 1:1 left join on right table with duplicates
- Replacing empty and null strings in Redshift with default strings when querying?
Related Questions in AWS-GLUE
- AWS GLUE child node execution order of same level
- Is there a way to import Redshift Connection in PySpark AWS Glue Job?
- Retrieving a list of all failed Glue jobs via CLI
- How do I change the data type in a Glue Crawler?
- Loading around 50gb of parquet data to Redshift taking indefinite time to load
- Glue Notebook not starting: Failed to start notebook
- old aws-glue libraries in the Glue streaming ETL job 4.0?
- Add File name column to Dynamic Frame
- How to test Glue jobs and Athena queries locally on dummy data?
- AWS Glue throws AWSBadRequestException when loading DynamicFrame from s3 with local Glue docker
- AWS Glue Insert and update into oracle table
- SQL query to extract incremental data from a table in SQL Server
- redshift spectrum type conversion from String to Varchar
- Apply transformation on nested json column in dataframe
- Access Denied while creating crawler
Related Questions in AWS-GLUE-SPARK
- AWS Glue: How to filter out data from DynamicFrame when date format is wrong or bad data
- How to set AWS Glue proxy settings
- Transfering the latest data from Redshift to dynamoDB by AWS Glue
- Aws Glue job output many small files
- Failed to start Glue Notebook server
- Convert pyspark script to awsglue script
- AWS Glue - fixed width text file - with header and footer
- Cross-Region AWS Glue Data Catalog access with Glue ETL
- how to convert spark datframe to pandas dataframe in AWS Glue
- SQL Server bcp tool on AWS GLUE job
- How to trigger a Glue job from another Glue job
- AWS Glue error - Invalid input provided while running python shell program
- Data load from Arena (DMS) to AWS S3
- Reading Spark Dataframe from Partitioned Parquet data
- How to catch an exception thrown from imported module in pyspark
Related Questions in AWS-GLUE-WORKFLOW
- AWS Glue Workflow to trigger email on any ETL job failure using Amazon SES
- AWS GLUE Pyspark job delete S3 folder unexpectly
- How to Dynamically create ETL jobs in AWS Glue with workflow
- Using AWS Glue Python jobs to run ETL on redshift
- Amazon Glue, Python library requirement files version update causes failure in AWS Glue Jobs
- Can Glue Workflow or Trigger get parameters from EventBridge
- Basic data validation in AWS Glue against schema/expected file format, including row level
- AWS glue get columns by name
- AWS CloudFormation Template for Orchestration of mutliple AWS Glue Jobs (combination of sequentially and parallel execution)
- AWS Glue Dev Endpoint - Cache Virtual Env
- AWS Glue Crawler creates multiple tables when reading empty files
- How to pass RunProperties while calling the glue workflow using boto3 and python in lambda function?
- Error in AWS Glue job "LAUNCH ERROR | File --class does not existPlease refer logs for details."
- AWS Glue -Add prefix to Job output file name
- Getting a String Instead of Array from Redshift while we dump data from DocumentDb to Redshift using Glue
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
There is no array data type in redshift. The only thing you could do is to explode the array on the way to redshift.