When writing target-mssql, I originally settled for using normal INT data types, kicking the can down the road when it came to long integers. Well, I caught up with the can, and I don’t have any better ideas now than I did then. Are there any negative consequences to mapping singer integers to sql bigints? Has anyone else solved this in better ways?

Does the schema info contain a maximum acceptable value for the field? If so can INT vs. BIGINT be inferred from that?

Good point. Since this is a target the schema can of course be anything, but checking for length might be a good first step.