Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Script Based Install Guide: Google BigQuery for RED 8

This is a guide to installing the WhereScape Enablement Pack for Google BigQuery for WhereScape RED 8.6.6.+ 

...

Scripts entirely drive the Enablement Pack Install process. The table below outlines these scripts, their purpose, and if Run as Administrator is required. 

#

Enablement Pack Setup Scripts

Script Purpose

Run as Admin

Intended Application

1

Setup_Enablement_Pack.ps1

Setup and configure a new RED Metadata Repository for BigQuery

Yes

New and Existing installations

2

install_WslPowershell_Modules.bat

Installs or updates WslPowershell Modules on this machine

Yes

New and Existing installations

3

install_WslPython_Modules.bat

Installs or updates WslPython Modules and required Python libs on this machine

Yes

New and Existing installations

4

import_python_templates.ps1

Imports or updates the Python Templates (in BETA) to a RED Metadata Repository. Also includes any Script Imports

no*

Existing installations

5

set_default_templates.ps1

Applies the RED Connection defaults in a RED Metadata Repository for Python or Powershell templates

no*

Existing installations

Note
  • Some systems executing Windows Powershell scripts are disabled by default, see troubleshooting for workarounds
  • install_WslPowershell_Modules.bat is required for the creation of pilot range table as scripts required for pilot table i.e create,pause and restart are currently in PowerShell only

...

Source Enablement Pack Support

Source Pack Name

Supported By Google BigQuery

Supported Features

Prerequisites/Permissions Required Google Big Query

Google Cloud Storage

Yes

Download to local and load

None

Google Drive

No

N/A

None

Azure Data Lake Storage Gen2

Yes

Download to local and load

None

Amazon S3

Yes

Download to local and load

None

Windows Parser

  1. CSV
  2. Excel
  3. JSON
  4. XML
  5. AVRO
  6. ORC
  7. PARQUET

Load Template, Source Properties will have option to select parser type to load the files.

Refer to Windows Parser Guide.

Troubleshooting and Tips

Run As Administrator

...