Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

disbursement_date saved as varchar #3

Open
paulrosenzweig opened this issue Sep 5, 2017 · 0 comments
Open

disbursement_date saved as varchar #3

paulrosenzweig opened this issue Sep 5, 2017 · 0 comments

Comments

@paulrosenzweig
Copy link
Contributor

disbursement_details__disbursement_date is being saved to redshift as a varchar. Other dates seem to be stored correctly, so maybe I introduced an error when adding disbursement date?

\d braintree.transactions 
                          Table "braintree.transactions"
                 Column                  |            Type             | Modifiers 
-----------------------------------------+-----------------------------+-----------
 _sdc_batched_at                         | timestamp without time zone | 
 _sdc_received_at                        | timestamp without time zone | 
 _sdc_sequence                           | bigint                      | 
 _sdc_table_version                      | bigint                      | 
 amount                                  | double precision            | 
 created_at                              | timestamp without time zone | 
 credit_card_details__customer_location  | character varying(128)      | 
 currency_iso_code                       | character varying(128)      | 
 customer_details__id                    | character varying(128)      | 
 id                                      | character varying(128)      | 
 order_id                                | character varying(128)      | 
 processor_authorization_code            | character varying(128)      | 
 processor_response_code                 | character varying(128)      | 
 processor_response_text                 | character varying(128)      | 
 status                                  | character varying(128)      | 
 type                                    | character varying(128)      | 
 updated_at                              | timestamp without time zone | 
 gateway_rejection_reason                | character varying(128)      | 
 refunded_transaction_id                 | character varying(128)      | 
 customer_details__email                 | character varying(128)      | 
 settlement_batch_id                     | character varying(128)      | 
 disbursement_details__disbursement_date | character varying(128)      | 
 disbursement_details__success           | boolean                     | 

The schema specification:

"disbursement_date": {
  "anyOf": [
    {
      "type": "string",
      "format": "date-time"
    },
    {
      "type": "null"
    }
  ]
},

This seems to match that of updated_at without the allowance for null.

"updated_at": {
  "type": "string",
  "format": "date-time"
},
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant