Created
April 25, 2014 16:17
-
-
Save halcyon/11294984 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--CREATE EXTENSION file_fdw; | |
--CREATE SERVER sfcsv FOREIGN DATA WRAPPER file_fdw; | |
CREATE FOREIGN TABLE sf_task ( | |
Id text, | |
WhoId text, | |
WhatId text, | |
Subject text, | |
ActivityDate text, | |
Status text, | |
Priority text, | |
OwnerId text, | |
Description text, | |
Type text, | |
IsDeleted text, | |
AccountId text, | |
IsClosed text, | |
CreatedDate text, | |
CreatedById text, | |
LastModifiedDate text, | |
LastModifiedById text, | |
SystemModstamp text, | |
IsArchived text, | |
ActivityOriginType text, | |
IsVisibleInSelfService text, | |
CallDurationInSeconds text, | |
CallType text, | |
CallDisposition text, | |
CallObject text, | |
ReminderDateTime text, | |
IsReminderSet text, | |
RecurrenceActivityId text, | |
IsRecurrence text, | |
RecurrenceStartDateOnly text, | |
RecurrenceEndDateOnly text, | |
RecurrenceTimeZoneSidKey text, | |
RecurrenceType text, | |
RecurrenceInterval text, | |
RecurrenceDayOfWeekMask text, | |
RecurrenceDayOfMonth text, | |
RecurrenceInstance text, | |
RecurrenceMonthOfYear text, | |
RecurrenceRegeneratedType text, | |
Event_Status__c text, | |
Hours__c text, | |
Activity_Type_2__c text, | |
qbdialer__CallRecordingURL__c text, | |
qbdialer__Call_Date_Time__c text, | |
qbdialer__Call_Dial_Number__c text, | |
qbdialer__Call_Hour__c text, | |
qbdialer__Call_Lead_Status__c text, | |
qbdialer__Call_Ring_Time__c text, | |
qbdialer__Call_Time_Zone__c text, | |
qbdialer__Callback_Date_Time__c text, | |
qbdialer__ImpressionId__c text, | |
qbdialer__SMSReminder__c text) SERVER sfcsv | |
OPTIONS ( filename '/home/salesforce/archive/salesforce/Task.csv', format 'csv', header 'true'); | |
ALTER TABLE sf_task OWNER TO salesforce; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment