Table of Contents

Search

  1. Preface
  2. Introduction to Google Cloud Storage V2 Connector
  3. Google Cloud Storage V2 connections
  4. Mappings for Google Cloud Storage
  5. Migrating a mapping
  6. Upgrading to Google Cloud Storage V2 Connector
  7. Appendix A: Data type reference

Google Cloud Storage V2 Connector

Google Cloud Storage V2 Connector

Wildcard characters for mappings in advanced mode

Wildcard characters for mappings in advanced mode

When you create a mapping in advanced mode to read data from an Avro, flat, JSON, ORC, or Parquet file, you can use wildcard characters to specify the source file name.
To use wildcard characters for the source file name, enable the
Is Directory
and
Allow Wildcard Characters
options in the advanced source properties.
When you read an Avro, JSON, ORC, Parquet, or flat file, you can use the
?
and
*
wildcard characters to define one or more characters in a search.
You can use the following wildcard characters:
? (Question mark)
The question mark character (?) allows one occurrence of any character. For example, if you enter the source file name as
a?b.txt
, the Secure Agent reads data from files with the following names:
  • a1b.txt
  • a2b.txt
  • aab.txt
  • acb.txt
* (Asterisk)
The asterisk mark character (*) allows zero or more than one occurrence of any character. If you enter the source file name as
a*b.txt
, the Secure Agent reads data from files with the following names:
  • aab.txt
  • a1b.txt
  • ab.txt
  • abc11b.txt

0 COMMENTS

We’d like to hear from you!