Skip to content

Instantly share code, notes, and snippets.

@Mikulas

Mikulas/import-vpc-flow-log.sql

Created July 27, 2017 08:20
Show Gist options
  • Save Mikulas/670fe6ae196532b84f320b5fc07a854b to your computer and use it in GitHub Desktop.
Save Mikulas/670fe6ae196532b84f320b5fc07a854b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
import-vpc-flow-log.sql
COPY vpc FROM '/SOME/PATH/000000'
WITH (
FORMAT CSV,
DELIMITER ' ',
NULL '-' -- some Flog Log entries will have unset fields with '-', this normalizes the value to NULL
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment